Simple nested if statement

M

mike_vr

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(A2>10000,1.5,IF(3500<A2<10000,1,IF(A2<3500,0.5,1)))

Thanks in advance,

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Further If statement thoughts... 4
Simple nested if and statement 2
IF Statement or VLOOKUP 1
IF Statement Problem 4
Nested IF statement 3
What Function to use? 7
Nested VLOOKUP in IF statement 2
How to do an IF statement that copy data based on a partial match 0

Top