How do I write this formula

B

billy boy

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
 
J

John

try =IF(AND(B4>91000,B4<99000),"ship",IF(AND(B4>125000,B4<137000),"don't
ship",IF(AND(B4>146000,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)
 
P

Peo Sjoblom

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
 
E

Elkar

Try this:

=IF(AND(B4>91000,B4<99000),"ship",IF(AND(B4>125000,B4<137000),"don't
ship",IF(AND(B4>146000,B4<160000),"beater","no good")))

HTH,
Elkar
 
Top