Formula for Complete/Incomplete

Phil H · #1 08-09-2016, 05:07 AM

Need a formula in cell G29: if there is an X in any cell in the range H29:Z29, then Incomplete, else Complete. All cells being empty means complete.

=IF((H46:Z46)="x","incomplete","complete") does not work - returns #VALUE!.

Phil H · #2 08-10-2016, 06:52 AM

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")))

NoSparks · #3 08-10-2016, 11:21 AM

try this in G29 and drag down

=IF(COUNTIF($H29:$Z29,"x")>0,"Incomplete",IF(COUNT IF($H29:$Z29,"")=19,"Complete","Incomplete"))

EDIT: I can't get rid of the space in the second COUNTIF

Phil H · #4 08-10-2016, 12:21 PM

Thanks NoSparks - works exactly as needed. I toyed around with the count thing but couldn't figure it out. You've saved me a lot of time and aggravation.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to show planned% complete and actual% complete on the (Project Overview) dashboard report?	zislam14	Project	3	12-17-2015 03:03 PM
Formula for filter "Incomplete Tasks for User..."	patrickd123	Project	1	04-07-2015 08:15 AM
sentences are incomplete in word 2007	jirado	Word	1	11-09-2014 01:32 PM
physical complete %, regular work, vs % complete	ketanco	Project	1	06-16-2014 11:08 AM
Merge from Excel sheet into Word Incomplete	gsandle	Office	0	07-16-2013 11:51 AM