View Single Post
 
Old 08-09-2016, 05:07 AM
Phil H Phil H is offline Windows XP Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default 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.
Reply With Quote