Forum Discussion

Copper Contributor

Aug 25, 2022

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...

excel

Formulas and Functions

HansVogelaar

Aug 25, 2022

Dan_Schiller

=IF(J3="","N/A",IF(OR(AND(ISNUMBER(SEARCH("1",J3)),O3=""),AND(ISNUMBER(SEARCH("7",J3)),Q3="")),"No","Yes"))

HansVogelaar

MVP

Aug 25, 2022

Dan_Schiller

How about

=IF(AND(O3="",OR(ISNUMBER(SEARCH({"1","7"},J3)))),"No","Yes")

Dan_Schiller
Copper Contributor
Aug 25, 2022
Thanks, but I want to see if there is a "1" in J3, then I'd like to check if there is something in the corresponding "O" cell, and if there is a "7" in J3, then I'd want to see if there is something in the corresponding "Q" cell. Based on what number is in J3, I'd want it to check the proper cell for the presence of data.

Does that make sense?
- HansVogelaar
  MVP
  Aug 25, 2022
  Dan_Schiller
  
  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")
  - Dan_Schiller
    Copper Contributor
    Aug 25, 2022
    HansVogelaar
    
    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