CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formulaformulanested-if
LDX
LDX

Reputation: 71

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";""))

Upvotes: 1

Views: 47

Answers (1)

player0
player0

Reputation: 1

try:

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

Upvotes: 2

Related Questions