Calculations based on cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure if this is possible or not but what I would like to do is take a
value of a cell say E2 and then in another cell perform a calculation that
varies depending on the value in E2, for example:

If E2 is between 0.01 and 29.99 calculate E2*5.25%
or
If E2 is between 30.00 and 599.99 then calculate 1.57+(E2-29.99)*3.25%

In another cell I would like to have a set value inserted based on the value
of E2, for example:

If E2 is between 0.01 and 0.99 then insert 0.15
If E2 is between 1.00 and 4.99 then insert 0.20
If E2 is between 5.00 and 14.99 then insert 0.35 etc.

Is any of this possible?
 
Try the two formulas:

=CHOOSE(MATCH(E2,{0.01,30,600}),E2*5.25%,1.57+(E2-29.99)*3.25%,NA())

=LOOKUP(E2,{0.01,1,5},{0.15,0.2,0.35})
 
Thanks Lori,

They work perfectly.

Lori said:
Try the two formulas:

=CHOOSE(MATCH(E2,{0.01,30,600}),E2*5.25%,1.57+(E2-29.99)*3.25%,NA())

=LOOKUP(E2,{0.01,1,5},{0.15,0.2,0.35})
Click to expand...
 
Back
Top