| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blamk cells and 0 values
Hi,
Can anyone tell me how to differentiate between blank cells and cells with a 0 value? regards Gavin |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blamk cells and 0 values
=ISNUMBER(A1)
returns False for blank True for 0 Regards, Stefi €˛gtm16€¯ ezt Ć*rta: Hi, Can anyone tell me how to differentiate between blank cells and cells with a 0 value? regards Gavin |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blamk cells and 0 values
Hi
=ISBLANK(A1) Returns TRUE for a blank cell and FALSE for an empty string or zero Mike "gtm16" wrote: Hi, Can anyone tell me how to differentiate between blank cells and cells with a 0 value? regards Gavin |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blamk cells and 0 values
On Dec 12, 9:24 am, Stefi wrote:
=ISNUMBER(A1) returns False for blank True for 0 Regards, Stefi „gtm16" ezt ķrta: Hi, Can anyone tell me how to differentiate between blank cells and cells with a 0 value? regards Gavin- Hide quoted text - - Show quoted text - Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blamk cells and 0 values
You are welcome! Thanks for the feedback!
Stefi €˛gtm16€¯ ezt Ć*rta: On Dec 12, 9:24 am, Stefi wrote: =ISNUMBER(A1) returns False for blank True for 0 Regards, Stefi €˛gtm16" ezt Ć*rta: Hi, Can anyone tell me how to differentiate between blank cells and cells with a 0 value? regards Gavin- Hide quoted text - - Show quoted text - Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blamk cells and 0 values
Some functions treat them differently. AVERAGE ignores blanks but recognizes
zeros. -- Gary''s Student - gsnu2007b "gtm16" wrote: Hi, Can anyone tell me how to differentiate between blank cells and cells with a 0 value? regards Gavin |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blamk cells and 0 values
A blank cell is like Saddam Hussein.
A cell with zero is like George Bush. not much dif Ok, not on topic, so ..... neither XL. "gtm16" wrote in message ... Hi, Can anyone tell me how to differentiate between blank cells and cells with a 0 value? regards Gavin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| skip cells with zero values in chart (cells not empty) | Charts and Charting in Excel | |||
| Assigning values to other cells from one cells formula | Excel Discussion (Misc queries) | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Linear Mode
