Pivot Table #Div/0!

[Guest]

Hello,
I'm building a pivot table and one of the calculations requires me to divide
a number into zero. for example 10/0 thus excel gives me a #DiS/0! error
message. Is there anyway that i can go into the pivot table and correct the
problem? Any suggestions would help.

Thanks
T

 

[Nick Hodge]

Trinni

Currently your calculated field will look something like this

=Value1/Value2

Instead you could use

=IF(ISERR(Value1/Value2),0,Value1/Value2)

This will return zero if there is an error (except #N/A!), else it will
return the value

Use "" instead of zero (two double quotes) if you want a blank cell returned
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog

 

[Guest]

Wow, Thank you soooooooo MUCH!

a Very happy

T