title: Applying multiple conditions to formula
body: <p>I have a situation where I need to apply several "value boundaries" to several different "starting positions" and then subsequently output the "ongoing position".</p>
  
  <p>The "value boundaries" are: &lt;500, >=500&lt;750, >750&lt;=850 and >850  </p>
  
  <p>The  "starting positions" are "Basic", "Standard", "Standard+", and "Platinum", </p>
  
  <p>The value boundaries are then applied and the "ongoing position" outputted, </p>
  
  <p>e.g. a person starting at "Basic" achieves 600 and then moves to "standard", or someone at "Platinum" gets 700 so reverts to "Standard+" etc etc, I have tried this with a nested IF to no avail .  </p>
  
  <p>Edit: it seems the solution is beyond a formula do I need VBA to solve this one?                          </p>