formula around wrong way

M

Micayla Bergen

i know i have this ass about
IF(NOT(OR((J3=0,"Stock not rated,(J3={1,2}),"SELL?",""),IF(OR,)))))
but im not sure of the specifics
basically if J3 = 0 then 'stock not rated', if 1 or 2 then SELL?
thanks
 
M

Micayla Bergen

i only need a sell prompt if it is 1 or 2, 3 - 5 is in our acceptable range
 
B

Biff

OK....

=IF(J3="","",IF(J3=0,"Stock not rated",IF(OR(J3={1,2}),"Sell","")))

OR....

=IF(J3="","",IF(J3=0,"Stock not rated",IF(J3<3,"Sell","")))

Biff
 
Top