Multiple IF STATEMENTS??

[mandy9]

I need to know how to create a formula where a Unit Price will populate in column I based on whether or not Column D is in a specific range. I tried to enter as multiple IF STATEMENTS but can't get it to work

IF D2<500 then cell equals 4.95
IF D2>499 but <2000 then cell equals 9.95
IF D2>1999 but <10000 the cell equals 16.95
IF D2>9999 then cell equals 29.95

Please help! Thanks!

 

[GerryPerry]

HI Mandy
several ways to do this but in terms of nested Ifs.. this will do it

=if(D2<500,4.95, if(d2<2000 , 9.95, if(d2<10000, 16.95, 29.95 )))

so only if d2 is >=500 does the second IF get looked at etc so no need to explicitly use the 499, 1999 etc

good luck

Gerry

 

[Somendra Misra]

Hi Mandy,

Try below formula also,

=LOOKUP(D2,{0,500,2000,10000},{4.95,9.95,16.95,29.95})

Regards,

 

[mandy9]

Its so simple! Thank you so much!

 

[GerryPerry]

I do as I am...... simple