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.
|