cell variables in IF formula

i have this formula (Thanks Biff)
=IF(J13="","",IF(J13=0,"Stock not rated",IF(OR(J13={1,2}),"Sell","")))
now i want to add in further variable - if J13 has "cmt" or "divs" then the
cell is blank, then if any of the above...
thank you

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

--
Return email address is not as DEEP as it appears
"Micayla Bergen" <[email protected]> wrote in message
news:[email protected]...
>i have this formula (Thanks Biff)
> =IF(J13="","",IF(J13=0,"Stock not rated",IF(OR(J13={1,2}),"Sell","")))
> now i want to add in further variable - if J13 has "cmt" or "divs" then
> the
> cell is blank, then if any of the above...
> thank you

Hi!

The formula will already take care of that.

As is, if J3 is ANY VALUE other than 0,1 or 2 then the formula cell will be
blank.

Biff

"Micayla Bergen" <[email protected]> wrote in message
news:[email protected]...
>i have this formula (Thanks Biff)
> =IF(J13="","",IF(J13=0,"Stock not rated",IF(OR(J13={1,2}),"Sell","")))
> now i want to add in further variable - if J13 has "cmt" or "divs" then
> the
> cell is blank, then if any of the above...
> thank you

woops, i meant if A13 is not cmt or divs, then the rest
i have this =IF(A13={"cmt","divs"},"",IF(J13="","",IF(J13=0,"Stock not
rated",IF(OR(J13={1,2}),"Sell","")))) but i dont think its right. because
only part of A13 will contain either cmt or divs, so would that be a search
if??

"Biff" wrote:

> Hi!
>
> The formula will already take care of that.
>
> As is, if J3 is ANY VALUE other than 0,1 or 2 then the formula cell will be
> blank.
>
> Biff
>
> "Micayla Bergen" <[email protected]> wrote in message
> news:[email protected]...
> >i have this formula (Thanks Biff)
> > =IF(J13="","",IF(J13=0,"Stock not rated",IF(OR(J13={1,2}),"Sell","")))
> > now i want to add in further variable - if J13 has "cmt" or "divs" then
> > the
> > cell is blank, then if any of the above...
> > thank you
>
>
>

Hi!

Try this:

=IF(OR(ISNUMBER(SEARCH({"cmt","divs"},A13)),J3=""),"",IF(J3=0,"Stock not
rated",IF(J3<3,"Sell","")))

Here's a posting tip for you:

Why not just ask one question and give all of the appropriate infomation all
at one time instead of posting multiple times and adding more and more
conditions onto to the original question? That would make finding all of the
replies easier and they'd all be in one thread!

Just a thought! <g>

Biff

"Micayla Bergen" <[email protected]> wrote in message
news:[email protected]...
> woops, i meant if A13 is not cmt or divs, then the rest
> i have this =IF(A13={"cmt","divs"},"",IF(J13="","",IF(J13=0,"Stock not
> rated",IF(OR(J13={1,2}),"Sell","")))) but i dont think its right. because
> only part of A13 will contain either cmt or divs, so would that be a
> search
> if??
>
> "Biff" wrote:
>
>> Hi!
>>
>> The formula will already take care of that.
>>
>> As is, if J3 is ANY VALUE other than 0,1 or 2 then the formula cell will
>> be
>> blank.
>>
>> Biff
>>
>> "Micayla Bergen" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> >i have this formula (Thanks Biff)
>> > =IF(J13="","",IF(J13=0,"Stock not rated",IF(OR(J13={1,2}),"Sell","")))
>> > now i want to add in further variable - if J13 has "cmt" or "divs" then
>> > the
>> > cell is blank, then if any of the above...
>> > thank you
>>
>>
>>

Thanks Biff. i do try to give all relevant info but its not until i implement
suggestions that i find further things that i have wrong or inadequate, but i
will keep that in mind
:o)

"Biff" wrote:

> Hi!
>
> Try this:
>
> =IF(OR(ISNUMBER(SEARCH({"cmt","divs"},A13)),J3=""),"",IF(J3=0,"Stock not
> rated",IF(J3<3,"Sell","")))
>
> Here's a posting tip for you:
>
> Why not just ask one question and give all of the appropriate infomation all
> at one time instead of posting multiple times and adding more and more
> conditions onto to the original question? That would make finding all of the
> replies easier and they'd all be in one thread!
>
> Just a thought! <g>
>
> Biff
>
> "Micayla Bergen" <[email protected]> wrote in message
> news:[email protected]...
> > woops, i meant if A13 is not cmt or divs, then the rest
> > i have this =IF(A13={"cmt","divs"},"",IF(J13="","",IF(J13=0,"Stock not
> > rated",IF(OR(J13={1,2}),"Sell","")))) but i dont think its right. because
> > only part of A13 will contain either cmt or divs, so would that be a
> > search
> > if??
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> The formula will already take care of that.
> >>
> >> As is, if J3 is ANY VALUE other than 0,1 or 2 then the formula cell will
> >> be
> >> blank.
> >>
> >> Biff
> >>
> >> "Micayla Bergen" <[email protected]> wrote in
> >> message
> >> news:[email protected]...
> >> >i have this formula (Thanks Biff)
> >> > =IF(J13="","",IF(J13=0,"Stock not rated",IF(OR(J13={1,2}),"Sell","")))
> >> > now i want to add in further variable - if J13 has "cmt" or "divs" then
> >> > the
> >> > cell is blank, then if any of the above...
> >> > thank you
> >>
> >>
> >>
>
>
>