Excel If statement

[Simmy1234]

Hi Guys

Please help me with the following :

I want to say the following ‘if’ statement:

If A1 is <2500, then put in 0
If A1 is between 2501 and 5000, then put in -5
If A1 is between 5001 and 7500, then put in -10
If A1 is >7501, then put in -15

 

[Airfix9]

You could use a lookup statement:

=LOOKUP(A1,{0,2501,5001,7501},{0,-5,-10,-15})

 

[Simmy1234]

Hi Guys

Please help me with the following:

I want to say the following ‘if’ statement:

If A1 is <2500, then put in 0
If A1 is between 2501 and 5000, then put in -5
If A1 is between 5001 and 7500, then put in -10
If A1 is >7501, then put in -15

 

[Zakkaroo]

Hi Guys

Please help me with the following:

I want to say the following ‘if’ statement:

If A1 is <2500, then put in 0
If A1 is between 2501 and 5000, then put in -5
If A1 is between 5001 and 7500, then put in -10
If A1 is >7501, then put in -15

Might be long winded, but this should work.

=IF(A1<=2500,0,IF(AND(A1>2500,A1<=5000),"-5",IF(AND(A1>5000,A1<=7500),"-10",IF(A1>7500,"-15",0))))

 

[Murali1881]

Hi Simmy,

Try this,

=IF(A1<=2500,0,IF(A1<=5000,-5,IF(A1<=7500,-10,-15)))

Thanks

Murali

 

[Airfix9]

My lookup is more compact!