How do I write this formula

If b4 is between 91000 and 99000 then say ship if b4 is between 125000 and
137000 say dont ship if b4 is between 146000 and 160000 say beater any other
number say no good?

Thanks

try =IF(AND(B491000,B4<99000),"ship",IF(AND(B4125000 ,B4<137000),"don't
ship",IF(AND(B4146000,B4<160000),"beater","no good")))
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"billy boy" wrote:

How do I write this formula

If b4 is between 91000 and 99000 then say ship if b4 is between 125000 and
137000 say dont ship if b4 is between 146000 and 160000 say beater any other
number say no good?

Thanks

One way

=VLOOKUP(B4,{0,"No Good";91000,"Ship";99001,"No Good";125000,"Don't
Ship";137001,"No Good";146000,"Beater";160001,"No Good"},2)


if you don't want 99000 to be included in hip category change it from 99001
to 99000, do the same for the other number ranges

Regards,

Peo Sjoblom
"billy boy" wrote in message
...
How do I write this formula

If b4 is between 91000 and 99000 then say ship if b4 is between 125000
and
137000 say dont ship if b4 is between 146000 and 160000 say beater any
other
number say no good?

Thanks

Try this:

=IF(AND(B491000,B4<99000),"ship",IF(AND(B4125000 ,B4<137000),"don't
ship",IF(AND(B4146000,B4<160000),"beater","no good")))

HTH,
Elkar



"billy boy" wrote:

How do I write this formula

If b4 is between 91000 and 99000 then say ship if b4 is between 125000 and
137000 say dont ship if b4 is between 146000 and 160000 say beater any other
number say no good?

Thanks