View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
StephanieH StephanieH is offline
external usenet poster
 
Posts: 95
Default #DIV/0! in PivotTable

I have a basic calculated field in my Pivot Table = Bal\Num. I get a Div
when the Bal and Num are empty. How can I write an IF statement so that the
field remains blank if the Num is empty?

A regular formula like
If(Bal="","",Bal/Num) would normally work.