How to replace #REF! with 0
how about something like this
=IF(ISERROR(A1),0,A1)
HTH,
Barb Reinhardt
"Margo" wrote:
I am currently pulling data from a pivot table to a report, but everytime the
pivot table doesn't have that specific data it shows #REF! on my report. I
want to change that to show 0 if there is no data. How do I fix this problem?
--
Margo
|