Using IF statement with GETPIVOTDATA

Hell all;

I have an excel spreadsheet that is linked to a pivot table. The cell will reflect what ever the pivot reference link is behind it.
Here's my problem, if the link doesn't exist (Null) I want the cell to reflect "0" (Zero).
I assumed the following formula work but it doesn't

=IF(=GETPIVOTDATA("SEAT AVAL",'ATRRS PIVOT'!$A$3,"MOS","13D1","FY","2009","QUARTER","Q1 ") Is Null, "0", =GETPIVOTDATA("SEAT AVAL",'ATRRS PIVOT'!$A$3,"MOS","13D1","FY","2009","QUARTER","Q1 "))


Any ideas on how to make this work would be appreciated. Thanks

Flynjack

If allows me to enter this formula without any error prompts; however, the value of the field only shows #REF! regardless if the linked cell has a value or Is Null.

Thanks for the space cath after Q1. That was probably something that had to be fixed anyway. After making the correction I still receive the #REF! code. But this makes sense because "0" should only appear if there is no reference in the PIVOT chart. Is there a way of saying if "X" doesn't exist in a PIVOT, then show me "0", and if "X" does exit in the PIVOT show me what "X" is.

You are a genious. It worked. Thanks.