formula around wrong way

i know i have this *** 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

Hi!

Here's one way:

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

Biff

"Micayla Bergen" <[email protected]> wrote in message
news:[email protected]...
>i know i have this *** 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

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

"Biff" wrote:

> Hi!
>
> Here's one way:
>
> =IF(J3="","",IF(J3>0,"Sell","Stock not rated"))
>
> Biff
>
> "Micayla Bergen" <[email protected]> wrote in message
> news:[email protected]...
> >i know i have this *** 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
>
>
>

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

"Micayla Bergen" <[email protected]> wrote in message
news:[email protected]...
>i only need a sell prompt if it is 1 or 2, 3 - 5 is in our acceptable range
>
> "Biff" wrote:
>
>> Hi!
>>
>> Here's one way:
>>
>> =IF(J3="","",IF(J3>0,"Sell","Stock not rated"))
>>
>> Biff
>>
>> "Micayla Bergen" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> >i know i have this *** 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
>>
>>
>>