Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions | |||
can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions |