For every row:
In col A I need to test a couple other cells in the row for values (col B,C,D)
Col B,C will have text or blank - no problem there
Col D may contain
blank (empty) or text
blank or text based on a formula
Situation 1 comes about when I COPY the data in the cells to remove the formula and have hard data.
How do I test for a blank returned by a formula?
A3 contains =IF(ISBLANK(B3),IF(ISBLANK(C3),IF(ISBLANK(D3),"",A2),A2),A2)
D3 contains =IF(ISBLANK(E3),IF(ISBLANK(F3),"",D2),D2)
E3 ans F3 are BLANK, putting a BLANK into D3. But D3 has a formula so A3 does not see the BLANK