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" wrote in message
...
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" wrote in message
...
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,"S tock 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" wrote in message
...
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" wrote in message
...
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,"S tock 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" wrote in
message
...
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" wrote in message
...
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,"S tock 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" wrote in
message
...
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