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