calculated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

i have a pivot table in which i entered a calculated field. some of the
values have a #DIV/0! so i thought i would try to modify the formula to be
somehting like :

if (iserror('field1'/'field2'),"0",'field1'/'field2'))

but i am getting an error.

what should i do?

thanks in advance,
geebee
 
geebee,

Try =if(field2<>0,field1/field2,0)
or
=IF(ISERROR(Field1/Field2),0,(Field1/Field2))
 
Back
Top