Multi conditional If statement. I think

[rkm140]

The problem I have might be easily solved and I am just over looking it.

I have four conditions with a range in each condition, (I.E. $10 = 0-299, $25= 300-499,$56 = 500-799, $110 = 800+). I need to look a a set value and have it determine which condition it meets then do the action needed.


A1= 349

Have A1 evaluated and multiply it by the correct factor and reported in A2

[vlady]

maybe with lookup

=LOOKUP(A1,{0,300,500,800},{10,25,56,110})*A1

[Moo the Dog]

Please Login or Register  to view this content.

- Vince

If you want it multiplied by the value in a1, just add *A1 after the last parentheses like below:

Please Login or Register  to view this content.

[Moo the Dog]

maybe with lookup

=LOOKUP(A1,{0,300,500,800},{10,25,56,110})*A1

Nice one, vlady. I love learning new - EASIER - ways to do something.

- Vince

[vlady]

Welcome vince.