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";""))
CodePudding user response：
try:
=IF(($E6<=O$5)*($F6>=O$5); "A";
IF(($E6<=O$5)*($H6>=O$5); "X"; ))
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";""))
CodePudding user response：
try:
=IF(($E6<=O$5)*($F6>=O$5); "A";
IF(($E6<=O$5)*($H6>=O$5); "X"; ))