MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Check data range and return false value if a cell is blank

  • Follow


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
0
Reply Utf 6/1/2010 7:15:01 PM 

=IF(COUNTA(A1:R1)=18,"Complete","Incomplete")

-- 

HTH

Bob

"DavidS" <DavidS@discussions.microsoft.com> wrote in message 
news:4BFC7A2C-1DDE-446B-BA3C-10972F25EACC@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
0
Reply Bob 6/1/2010 7:42:58 PM 


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
0
Reply Utf 6/1/2010 8:12:01 PM
microsoft.public.excel.misc 79177 articles. 66 followers.

2 Replies
913 Views

(page loaded in 0.084 seconds)

Similiar Articles:

Check data range and return false value if a cell is blank ...
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

Formula that will not return "0" from a blank line ...
Check data range and return false value if a cell is blank ... Formula that will not return "0" from a blank line ... Check data range and return false value if a cell is ...

Blank Check? - microsoft.public.excel.worksheet.functions ...
Check data range and return false value if a cell is blank ... Example Check row A1:R1 and if at least one cell is empty then S1 should indicate "incomplete" otherwise ...

help with restricting paste in cells with data validation ...
... to data Help!!! - microsoft.public.excel.misc ... help with restricting paste in cells with data validation ... Check data range and return false value if a cell is blank ...

How do i check if the a named range is empty - microsoft.public ...
Check data range and return false value if a cell is blank ... Named Range on Another Workshe ... the one blank line ... formulas|Check ... How to Check If a Cell Is Empty ...

Returning Only Odd or Even Address Ranges - microsoft.public ...
... to the stumpage sheet, I have =(cell address ... formula that will look in the cell and return only the ... Check data range and return false value if a cell is blank ..... ...

VLOOKUP returns 0 (zero) when lookup cell is blank - microsoft ...
... range. > > C.T. wrote: > > > > Is there a reason why my column 1 data is returning blank ... Return empty cell ... Change cell value result from "FALSE" to blank or ...

Compare cells for same values via VBA. - microsoft.public.excel ...
... duplicate data ... or D22 is blank, then..." Any ideas? Private Sub CommandButton1_Click() If (Range("d21").Value ... and to return a True or False value (in cell A65 ...

Change cell value result from "FALSE" to blank or zero ...
... Cell in a Range - microsoft ... Change cell value result from "FALSE" to blank or ... cell value result from "FALSE" to blank or ... To Return Value_if_false As A Blank Cell ...

Paste Link to data Help!!! - microsoft.public.excel.misc ...
... For Each cell In rngS If dd.Cells(x, 2).Value = cell.Value ... with restricting paste in cells with data validation ... Check data range and return false value if ...

Check data range and return false value if a cell is blank ...
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

Check data range and return false value if a cell is blank ...
Excel Discussion (Misc queries) ... Example Check row A1:R1 and if at least one cell is empty then S1 should indicate ... =IF(COUNTA(A1:R1)=18,"Complete","Incomplete ...

Leaving Cells Blank with the Excel IF Function
=IF(logic test, value if true, value if false) The logic test is ... Having an IF function return a blank cell is similar to ... Excel Data Management: Free Email Course ...

Excel :: Basic IF Function. Return Cell Value Or Show Blank
Return Cell Value Or Show Blank For example if I were to take the data in ... returns the "false" value, it is looking to pull over a "blank" cell. ... to check a range of ...

How to Check If a Cell Is Empty in Excel Program? | eHow.com
If a cell is blank, that value will be zero according to ... the Excel worksheet with the data you want to check. ... value of "TRUE." Otherwise, it returns a value of "FALSE."

7/29/2012 9:35:06 PM


Reply:



Privacy Policy | All Times Are GMT(UTC) | powered by