return the message #reference!

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

Guest

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?
 
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 :-)
------------------------------­------------------------------­----------------
 
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(...
 
Back
Top