Error Handling in Excel

[kleinsim]

I am comparing matching entries in two pivot tables using the GETPIVOTDATA command. I'd rather not create another pivot table for what I am doing but I just found that I have several entries in one pivot table that do not appear in the other. As you know when I try to look up, say, the corresponding value for apples in a pivot table that only has entries for peaches, plums, and strawberries I get a #REF! error. I was wondering whether there is a way to stop such errors from occuring by checking whether it will occur before it is executed in a style such as this: if(B2=0,"Div by 0",B3/B2).

Thanks bunches

kleinsi

 

[schielrn]

Welcome to the Board!

You can do something to the fact like:

=if(iserror(B2),"Is error","Not error")

Hope that helps.