multiple if or function

[mojobaabby]

This works
=if(OR(F32<3000,F32<4000),0%,2%)
This does not
=if(OR(F32<3000,F32<4000,F32<5000),0%,2%,3%)
I have 7 different levels of discounts I need to do but I cant get past two without an error
Thanks for any help

[jeffreybrown]

Please amend your title to something searchable as per forum rules.

For an If statement there is a True and a False. You have too much going on.
IF(logical_test, value_if_true, [value_if_false])

Look at Excel's help file and while you are there check out Lookup
LOOKUP(lookup_value, lookup_vector, result_vector)

[NBVC]

IF() only takes on 3 arguments in total... the condition, the what to do if true and the what to do if false...

The OR() is the condition... you can only have 2 options after that.

I think you are looking for something more like:L

=Lookup(F32,{0,3001,4001},{0,0.02,0.03})

and you can add more... the first array represents the lower bounds and the second array the respective percentages.

...and yes, please do amend your title....

[mojobaabby]

another one solved thanks a heap