I'm working on a simple table fill-in template in Ecel 2007.
Here's my table headers including the test result column:
STAFF,ITEM,BLDG,Inspection report/notes,STATUS,TEST RESULT
I am trying to put a formula in column 6 (TEST RESULT) that tests for the following:
When all first 5 columns are blank, nothing shows in column 6
When anything is entered in one or more of any of the first 5 columns, then I want a message that states 'Incomplete' to appear in column 6
When all 5 fields have data, then column 6 s/b blank.
I would very much appreciate a solution without a macro if possible.