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))

"geebee" wrote:

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