Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet organized as:
WeekDay / WoodShop / Spa / Pool Monday / / 1 / 4 Tuesday/ / 2 / 2 Wednesday/ / 1 / 4 I used the Data/Subtotal/Average functionality to determine the average number of participants in each of the events over the period of time, and the Woodshop average's cell displays "#DIV/0". I understand that dividing 3 by 0 is an error, but I want Excel just to leave the cell blank. I've tried conditional formatting using the Is Formula / =iserror as suggested in Help, but Excel is ignoring this. Is there any way to make Excel do what I want? TIA, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
spell number | Excel Worksheet Functions | |||
Convert number into words | Excel Discussion (Misc queries) | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |