I am currently utilizing 3 columns with the following formula in the 3rd column
=IF(D4=C4,"PASSED","FAILED")
My problem is that if D4 and C4 have no data entered the E4 column displays PASSED while I need E4 to be blank if D4 and C4 have no data entered. Can you please help? Thanks.
Bookmarks