We help IT Professionals succeed at work.

Excel 2007 Formula help needed to test for empty cells

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.

TIA!


                                                                  
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2013
Commented:
If the 5 cells are A2:E2 try this formula in F2

=IF(OR(COUNTA(A2:E2)={0,5}),"","Incomplete")

regards, barry

Author

Commented:
Bingo - thanks for the fast response!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.