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" <MicaylaBergen@discussions.microsoft.com> wrote in message
news:0A71AE27-6806-498C-81C3-50CD682E2CA6@microsoft.com...
>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" <MicaylaBergen@discussions.microsoft.com> wrote in message
> news:0A71AE27-6806-498C-81C3-50CD682E2CA6@microsoft.com...
> >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" <MicaylaBergen@discussions.microsoft.com> wrote in message
news:4AB7A2E6-91E1-4373-9DDD-CB74AE15082F@microsoft.com...
>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" <MicaylaBergen@discussions.microsoft.com> wrote in
>> message
>> news:0A71AE27-6806-498C-81C3-50CD682E2CA6@microsoft.com...
>> >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
>>
>>
>>