Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am running a column with an if formula to return "" when false and then
when true to return what amounts to an expense ratio. there are cases where the expense ratio should show as 0. I am then running a pivot table to do the min/max of expense ratios. The problem I am running into is the fields that are populated with "" are filling as 0 on the pivot in addition to the fields that should rightly show 0. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank Pivot Cells | Excel Discussion (Misc queries) | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
Showing Zero for all blank cells in a range | Excel Discussion (Misc queries) | |||
blank cells showing up as a month 1 | Excel Worksheet Functions | |||
showing blank cells | Excel Discussion (Misc queries) |