View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
fabre jerome[_2_] fabre jerome[_2_] is offline
external usenet poster
 
Posts: 1
Default how do I remove #DIV/0! in a pivot table calculation field ?

Found a reply


"fabre jerome" wrote:

I do formulas in a pivot table, but in my database some fields are empty. So
when I do a calculation in the Pivot Table, the return for some values is
"#DIV/0!".
In the calculated field of the Pivot Table, I do an "if; than; else", but it
doesn't work.
Thanks in advance for your feedback.
Jef