Yes, I am new at this and I don't know...
Column B=Name
Column E=hours
Column F=Yes or No
Column H=result
Multiple tests per row: if hours are <20 and f is yes or no, the I want the name in B to appear in H, BUT if hours are >20 and f=no, then I want the name in B to appear in H.
=if(AND(E2<20.1,AND(F2="no",F2="yes")),B2,"")*OR(IF(AND(E2>20,AND(F2="No")),B2,"")) get a #value
=IF(E7<20.1,IF(F7="Yes",B7,IF(E7<20.1,IF(F7="No",B7,""),IF(E7>20,IF(F7="No",B7))))) I get a FALSE
Thank you!
Bookmarks