return the message #reference!

[E Petersen]

I am using the function getpivotdata in excel, and I ask for the total amount
on diffrent acounts I have in my pivottabel. If there are no data on the
acount I get the answer #reference! because the acount not exist in my
pivottabel. Insted I want to get 0.
How can I get this result?

 

[Ken Wright]

Try

=IF(ISERROR(Your_formula),0,your_formula)

Note though that this will trap all errors so may hide some other error as
well.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Barb Reinhardt]

Try

=if(iserror(getpivottable ...)=TRUE,0,getpivottable...)

 

[E Petersen]

Tanks for your answering. The formel woun't work in my excel. Instet I have
done this: =HVIS(ER.FEJL(-GETPIVOTDATA(Pivottabeller!$A$1:$O$20;$A8&"
"&C$6));0;-GETPIVOTDATA(Pivottabeller!$A$1:$O$20;$A8&" "&C$6)). In english
the formel will start with: =If(is.fail(...

 

[Ken Wright]

Thats OK, it's a similar solution.

Regards
Ken................