#1
|
|||
|
|||
Formula for Complete/Incomplete
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!. Last edited by Phil H; 08-09-2016 at 12:49 PM. Reason: Added formula comment. |
#2
|
|||
|
|||
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"))) |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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.
|
Tags |
formula, range formula |
|
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 |