Thread
: [Solved]
Formula for Complete/Incomplete
View Single Post
08-10-2016, 06:52 AM
Phil H
Windows XP
Office 2010 64bit
Advanced Beginner
Join Date: Jun 2010
Posts: 81
Partial Answer
This formula works for three cells. The range is 19 cells long, so how to condense this formula where all cells are included into one phrase?
=IF(H46="X","Incomplete",IF(I46="X","Incomplete",I F(J46="X","Incomplete","Complete")))
Phil H
View Public Profile
Find all posts by Phil H