IF #REF then display 0

Giganews Newsgroups
Subject: IF #REF then display 0
Posted by:  sprintorde‚Ķ@gmail.com
Date: 28 Jun 2006

I am using a PivotTable, and using the GETPIVOTDATA formula to popluate
data on a separate worksheet.  The colums are days of the month, but if
i don't have any data for that date it gives me a #REF.  Is there a way
i can include with my GETPIVOTDATA statement, that if it shows an error
or #REF, it will displya a 0 or leave it blank, that way it doesn't
mess up with the other data.

Let me know if you need any additional information.

Replies