Aug 25 2022 05:21 AM - edited Aug 25 2022 06:02 AM
Hello,
I am able to get either of these IF statements to work on their own, but I'm really trying to combine the two so I don't have to create additional columns in my spreadsheet to break it down into different parts. Each of these statements work on their own presently, but I can't seem to find a way to check the condition that's within that first column (J) and then look at the corresponding column (O or Q)
Here are my two IF statements:
=IF(ISNUMBER(SEARCH("1",J3)),IF(ISBLANK(O3),"No","Yes"))
=IF(ISNUMBER(SEARCH("7",J3)),IF(ISBLANK(Q3),"No","Yes"))
I think it has to do with adding in an OR somewhere when combining these formulas, but I can't seem to get it to work.
Any suggestions?
Thanks in advance!
Aug 25 2022 05:42 AM - edited Aug 25 2022 06:13 AM
Aug 25 2022 06:06 AM
Aug 25 2022 06:11 AM
My apologies - I didn't notice the O / Q difference.
=IF(OR(AND(ISNUMBER(SEARCH("1",J3)),O3=""),AND(ISNUMBER(SEARCH("7",J3)),Q3="")),"No","Yes")
Aug 25 2022 07:09 AM - edited Aug 25 2022 07:15 AM
This worked, thanks a lot!
The only other thing I didn't think of until now, is when J3 is blank. In those instances, I'd like for the result to be "No" or "N/A". Is that something that could be accounted for? If not, your last formula will be fine
Aug 25 2022 07:23 AM
Solution
=IF(J3="","N/A",IF(OR(AND(ISNUMBER(SEARCH("1",J3)),O3=""),AND(ISNUMBER(SEARCH("7",J3)),Q3="")),"No","Yes"))
Aug 25 2022 07:23 AM
Solution
=IF(J3="","N/A",IF(OR(AND(ISNUMBER(SEARCH("1",J3)),O3=""),AND(ISNUMBER(SEARCH("7",J3)),Q3="")),"No","Yes"))