Excel if/and
 

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

Excel if/and
 

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

"KarenB" wrote:

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

Excel if/and
 

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

"KarenB" wrote in message
...
How do I write this so that I can get the answer I need or can I?

"KarenB" wrote:

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

Excel if/and
 

Perfect, Thank You

"PCLIVE" wrote:

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

"KarenB" wrote in message
...
How do I write this so that I can get the answer I need or can I?

"KarenB" wrote:

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

Excel if/and
 

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KarenB" wrote in message
...
How do I write this so that I can get the answer I need or can I?

"KarenB" wrote:

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

Excel if/and
 

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


"KarenB" wrote:

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

Excel if/and
 

=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

On Mon, 16 Apr 2007 14:32:02 -0700, KarenB
wrote:

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

Excel if/and
 

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,1 00,1250))))



"KarenB" wrote in message
...
Perfect, Thank You

"PCLIVE" wrote:

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

"KarenB" wrote in message
...
How do I write this so that I can get the answer I need or can I?

"KarenB" wrote:

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

Excel if/and
 

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

"Ragdyer" wrote:

Try this:

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

Excel if/and
 

Thanks for solving my problem with this solution!!!

Jeremy

"Gord Dibben" wrote:

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

Excel if/and
 

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

"Teethless mama" wrote:

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

Excel if/and
 

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

"PCLIVE" wrote:

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,1 00,1250))))



"KarenB" wrote in message
...
Perfect, Thank You

"PCLIVE" wrote:

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

"KarenB" wrote in message
...
How do I write this so that I can get the answer I need or can I?

"KarenB" wrote:

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

Excel if/and
 

You're welcome.

But are you KarenB also?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"jerminski73" wrote in message
...
Thanks for solving my problem with this solution!!!
Jeremy

"Ragdyer" wrote:

Try this:

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