| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to distinguish zeros ("0") from blank cells?
I'm trying to figure out a way to get my formulas to distinguish cells with
no data from those that have a "0". Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to distinguish zeros ("0") from blank cells?
=LEN(A1)=0
returns TRUE for empty cell and FALSE for 0 =A1="" returns TRUE for empty cells and FALSE for 0 -- Regards, Peo Sjoblom "Clay888" wrote in message ... I'm trying to figure out a way to get my formulas to distinguish cells with no data from those that have a "0". Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to distinguish zeros ("0") from blank cells?
"Peo Sjoblom" wrote...
=LEN(A1)=0 returns TRUE for empty cell and FALSE for 0 =A1="" returns TRUE for empty cells and FALSE for 0 .... Both formulas also return TRUE for nonblank cells that evaluate to "". ISBLANK(x) and COUNT(x)=0 provide stricter tests for whether a cell contains nothing. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to distinguish zeros ("0") from blank cells?
certain functions like AVERAGE will ignore blanks.
If you tell us specifically what you are trying to do, we can help you figure it out. "Clay888" wrote: I'm trying to figure out a way to get my formulas to distinguish cells with no data from those that have a "0". Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - "(blank)" in rows and cells | Excel Discussion (Misc queries) | |||
| multiplying by blank cells input by "IF" functions | Excel Discussion (Misc queries) | |||
| Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
| How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Hybrid Mode
