Search code examples
if-statementgoogle-sheetsgoogle-sheets-formulaformulanested-if

Google Sheet outputs an error when combining two IFs


Can't figure our why the formula is wrong, it outputs an #error

=IF(AND(($E6<=O$5);($F6>=O$5));"A";"")OR(IF(AND(($E6<=O$5);($h6>=O$5));"X";""))

Solution

  • try:

    =IF(($E6<=O$5)*($F6>=O$5); "A"; 
     IF(($E6<=O$5)*($H6>=O$5); "X"; ))