hi, i use the formula below for the values to appear on cell g2. how do i make it into an array formula? thanks!
=IF(AND(ISBLANK(D2),ISBLANK(E2),ISBLANK(F2)),C2,IF(AND(ISBLANK(E2),ISBLANK(F2),ISBLANK(C2)),D2,IF(AND(ISBLANK(F2),ISBLANK(C2),ISBLANK(D2)),E2,IF(AND(ISBLANK(C2),ISBLANK(D2),ISBLANK(E2)),F2))))
Capture.JPG
Bookmarks