|
|
#1
08-09-2016, 05:07 AM
|
|||
|
|||
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. 
|
| 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 |
Windows XP 
Office 2010 64bit
Threaded Mode