Excel if/and

K

KarenB

I hope this makes sense!
I'm using Excel 03

if b2 is 34 or less then d2=250 and if b2 is between 35 to 39 then d2=500
and if b2 is between 40 to 44 then d2=750 and if b2 is between 45-49 then
d2=100 and if b2 =50 then d2=1250

Thanks
 
P

PCLIVE

One way:

=IF(B2<=34,250,IF(AND(B2>=35,B2<=39),500,IF(AND(B2>=40,B2<=44),750,IF(AND(B2>=45,B2<=49),1000,1250))))

I'm assuming between 45 and 49 = 1000 and not 100.
HTH,
Paul
 
K

KarenB

Perfect, Thank You

PCLIVE said:
One way:

=IF(B2<=34,250,IF(AND(B2>=35,B2<=39),500,IF(AND(B2>=40,B2<=44),750,IF(AND(B2>=45,B2<=49),1000,1250))))

I'm assuming between 45 and 49 = 1000 and not 100.
HTH,
Paul
Click to expand...
 
G

Gord Dibben

=LOOKUP(B2,{0,35,40,45,50},{250,500,750,1000,1250})

Entered in D2.

I assumed the 100 was a typo and should be 1000.


Gord Dibben MS Excel MVP
 
P

PCLIVE

No problem.

One comment though. I wrote the formula in the exact context of your
request description. However, it dawned on me that, though the formula
works fine, it is overkill. The better syntax for this formula would be as
posted by Teethless mama.

=IF(B2<35,250,IF(B2<40,500,IF(B2<45,750,IF(B2<50,100,1250))))
 
J

jerminski73

I finally understand how to use multiple arguments in excel!! Thanks for the
insight. See other replies though for what appears to me to be an easier
way..
Jeremy
 
Top