Excel if/and

[Guest]

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

 

[Guest]

How do I write this so that I can get the answer I need or can I?

 

[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

 

[Guest]

Perfect, Thank You

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

 

[Ragdyer]

Try this:

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

 

[Guest]

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

 

[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

 

[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))))

 

[Guest]

Thanks for solving my problem with this solution!!!
Jeremy

 

[Guest]

Thanks for solving my problem with this solution!!!

Jeremy

 

[Guest]

Thanks for solving my problem with this solution!!!
Jeremy

 

[Guest]

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

 

[RagDyeR]

You're welcome.

But are you KarenB also?