Display certain values in excel if criteria is met
Try:
=IF(NOT(AND(ISBLANK(D2), ISBLANK(E2))), H2, "")
Depending on the content of D2 and E2, you may need to substitute:
AND(D2="", E2="") for AND(ISBLANK(D2), ISBLANK(E2))
Try:
=IF(NOT(AND(ISBLANK(D2), ISBLANK(E2))), H2, "")
Depending on the content of D2 and E2, you may need to substitute:
AND(D2="", E2="") for AND(ISBLANK(D2), ISBLANK(E2))