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