Prev: Scales on Charts.
Next: Template on Server 2008
From: DavidS on 1 Jun 2010 15:15
Example
Check row A1:R1 and if at least one cell is empty then S1 should indicate
"incomplete" otherwise "complete" if every cell in the row has a value
From: Bob Phillips on 1 Jun 2010 15:42
=IF(COUNTA(A1:R1)=18,"Complete","Incomplete")

--

HTH

Bob

"DavidS" <DavidS(a)discussions.microsoft.com> wrote in message
news:4BFC7A2C-1DDE-446B-BA3C-10972F25EACC(a)microsoft.com...
> Example
> Check row A1:R1 and if at least one cell is empty then S1 should indicate
> "incomplete" otherwise "complete" if every cell in the row has a value


From: Tom-S on 1 Jun 2010 16:12
Try yhis formula in cell S1:

=IF(COUNTBLANK(A1:R1)>0,"Incomplete","Complete")

Note that this will only check for blank cells - it won't check whether the
cell contents are valid data for your purposes.

Regards,

Tom


"DavidS" wrote:

> Example
> Check row A1:R1 and if at least one cell is empty then S1 should indicate
> "incomplete" otherwise "complete" if every cell in the row has a value
 | 
Pages: 1
Prev: Scales on Charts.
Next: Template on Server 2008