formula around wrong way

[Guest]

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

 

[Biff]

Hi!

Here's one way:

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

Biff

 

[Guest]

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

 

[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