| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#div/0 error
=Average(If(E4=0,"",S4:X4))
The answer always returns 0.00 even though data to be averaged are in cells. Tried several varations but to no avail I need to get rid of #DIV/0! and leave cells blank or 0.00 (If no values yet) Prefer blank cells Some sells may stay blank for years others change monthly, there are hundreds of #DIV/0! which makes it hard to see values which are important. Thanks for any help.......... Earl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 error
On 8 mar, 23:49, Earl1704 wrote:
=Average(If(E4=0,"",S4:X4)) The answer always returns 0.00 even though data to be averaged are in cells. Tried several varations but to no avail I need to get rid of #DIV/0! and leave cells blank or 0.00 (If no values yet) Prefer blank cells Some sells may stay blank for years others change monthly, there are hundreds of #DIV/0! which makes it hard to see values which are important. Thanks for any help.......... Earl Good evening Maybe the data to be averaged is not considered as numeric (are there quotes ? Or cells are text formated ?) Hope it helps |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 error
Maybe this is what you had in mind...
=IF(E4=0,"",IF(COUNT(S4:X4),AVERAGE(S4:X4),"")) -- Biff Microsoft Excel MVP "Earl1704" wrote in message ... =Average(If(E4=0,"",S4:X4)) The answer always returns 0.00 even though data to be averaged are in cells. Tried several varations but to no avail I need to get rid of #DIV/0! and leave cells blank or 0.00 (If no values yet) Prefer blank cells Some sells may stay blank for years others change monthly, there are hundreds of #DIV/0! which makes it hard to see values which are important. Thanks for any help.......... Earl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Linear Mode
