Simple nested if statement
 

Hi all

Very basic If statement, but my Excel's a bit rubbish!

Trying to get the following result in column B with a whole range of values
in column B:

0-3,500 = 0.5%
3,501-10,000 = 1.0%
10,001-upwards = 1.5%

Using the following formula but some of the results are coming out
incorrectly. Also, I don't think it's the best way to do this?

=IF(A210000,1.5,IF(3500<A2<10000,1,IF(A2<3500,0.5 ,1)))

Thanks in advance,

Mike

Simple nested if statement
 

Hi Mike

Try this:

=IF(A2<=3500,0.5,IF(A2<=10000,1,1.5))

Regards,
Per

"mike_vr" skrev i meddelelsen
...
Hi all

Very basic If statement, but my Excel's a bit rubbish!

Trying to get the following result in column B with a whole range of
values
in column B:

0-3,500 = 0.5%
3,501-10,000 = 1.0%
10,001-upwards = 1.5%

Using the following formula but some of the results are coming out
incorrectly. Also, I don't think it's the best way to do this?

=IF(A210000,1.5,IF(3500<A2<10000,1,IF(A2<3500,0.5 ,1)))

Thanks in advance,

Mike