Hiya,
I am not Pro with Formulas but I want to maintain a file for all the details about employee documents submitted.
Eg. Column A to Column F has all the required document name viz.. Photo ID proof, Address Proof etc.
The Final column "G" I have to Manually enter "Incomplete" if any of the cells are empty.
I tried the IF & Then Formula (after a lot research on this site) but it works fine until the first 3 columns and then I get confused myself :P
Is there a shorter way to simply check value of each column and if any of the column between A to F is empty "Blank" then I get a msg "Incomplete" in the Final Column.
Any Help will be appreciated.
Thanks
Lin
Bookmarks