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})


Michael Wright wrote:

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?

Thanks Lori,

They work perfectly.

"Lori" wrote:

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})


Michael Wright wrote:

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?