cell variables in IF formula

M

Micayla Bergen

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
 
J

Jack Sheet

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

Biff

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
 
M

Micayla Bergen

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??
 
B

Biff

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
 
M

Micayla Bergen

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
:eek:)
 
Top