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

Dont use the extra = signs... = means the start of a formula in a cell, but once it is a formula, it says a formaly so you only need one = sign to start.

=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"))

I think that should work.

Mailman;

Took out the "=" signs based on your recommendation. Unfotunatley, excel still doesn't like it. Any other ideas?

I was so bussy tripping over your first problem I didnt notice the second...

"Is null" is a database thing, in excel you use "Isblank (CellReference)"

I have tried the Isblank command and it still doesn't work.

Should work like a charm!

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

Got it to work with ISERR instead of ISBLANK. Thanks for the help.

Got it to work with ISERR instead of ISBLANK. Thanks for the help.

That's good. But be sure everything works as you intend in several scenarios, because in some contexts, ISERR (and other error functions) can obscure future problems.

(Note that ISERROR was the function used in 2000/2002/2003. Did this change with 2007?)