Forum Discussion
Solved
Combining 2 If Statements
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 dow...
=IF(J3="","N/A",IF(OR(AND(ISNUMBER(SEARCH("1",J3)),O3=""),AND(ISNUMBER(SEARCH("7",J3)),Q3="")),"No","Yes"))
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
=IF(J3="","N/A",IF(OR(AND(ISNUMBER(SEARCH("1",J3)),O3=""),AND(ISNUMBER(SEARCH("7",J3)),Q3="")),"No","Yes"))- That's incredible, thanks again!