M
mariaivelisse77
Hi,
I am working with a spreadsheet and I'm trying to use the getpivot data
function with dollar amounts. It has worked for all other figures on my
spreadsheet but when I try to get a number that is $$ the function isn't
working I get the REF error.
My formula looks like this: =GETPIVOTDATA("Average Salary",Sheet1!$A$6,"C-R
Band",".85-.89")
Thanks for any help you can offer!
MIM
I am working with a spreadsheet and I'm trying to use the getpivot data
function with dollar amounts. It has worked for all other figures on my
spreadsheet but when I try to get a number that is $$ the function isn't
working I get the REF error.
My formula looks like this: =GETPIVOTDATA("Average Salary",Sheet1!$A$6,"C-R
Band",".85-.89")
Thanks for any help you can offer!
MIM