software

I am trying to use the getpivot data for an interactive spreadsheet. Some of
the getpivotdata functions that I am creating do not exist yet so I am
getting an error. (it is a live worksheet that gets modified daily). I
figured if I can create an IF statement to verify for numerical data, then
maybe I can bypass that error. Is there a way to check for numerical data.
This is what I am writing IF(getpivotdata(@#$%)gt;=0 [this is where I would
want my numerical check], getpivotdata(@#$%), 0). Basically I want to
process a check to see if the getpivot data is a number. If it is not, then
I am assuming that it is an error and therefore the if statement would place
a 0. Is there any way to do this. I know I should be using ACCESS but we
don't have that available and I am trying everything I can with excel.

Thanks

Omar

You may use the functions ISERROR, or ISNA, instead of a numeric calculation.
=IF(ISERROR(GETPIVOTDATA(@#$%)),0,GETPIVOTDATA(@#$ %))

Hope this helps,
Miguel.

quot;Omarquot; wrote:

gt; I am trying to use the getpivot data for an interactive spreadsheet. Some of
gt; the getpivotdata functions that I am creating do not exist yet so I am
gt; getting an error. (it is a live worksheet that gets modified daily). I
gt; figured if I can create an IF statement to verify for numerical data, then
gt; maybe I can bypass that error. Is there a way to check for numerical data.
gt; This is what I am writing IF(getpivotdata(@#$%)gt;=0 [this is where I would
gt; want my numerical check], getpivotdata(@#$%), 0). Basically I want to
gt; process a check to see if the getpivot data is a number. If it is not, then
gt; I am assuming that it is an error and therefore the if statement would place
gt; a 0. Is there any way to do this. I know I should be using ACCESS but we
gt; don't have that available and I am trying everything I can with excel.
gt;
gt; Thanks
gt;
gt; Omar