Rounding up values
 

I have a spreadsheet with the following formula in cell L35:

=IF(B35="","",IF(ISERROR(GETPIVOTDATA('LOST MEMBERS PIVOT
TABLE'!A33,Calculator!$B35&" Total")),"£0",GETPIVOTDATA('LOST MEMBERS PIVOT
TABLE'!A33,Calculator!$B35&" Total")))

I've formatted the cell so it shows zero decimal places and the result
appears as -11. However, I noticed a problem whereby this result does not
match the value in K35 (which has been put in place to manually calculate the
relevant cells to check that L35 is correct), so when this value is copied
into another cell, via paste special (values), the actual value is:
-11.1000000000001

Any ideas why this is? I think I may need to have the formula
=round(L35,2), but is there any way to include this in the original formula
detailed above?

Rounding up values
 

=IF(B35="","",ROUND(IF(ISERROR(GETPIVOTDATA('LOST MEMBERS PIVOT
TABLE'!A33,Calculator!$B35&" Total")),"£0",GETPIVOTDATA('LOST MEMBERS PIVOT
TABLE'!A33,Calculator!$B35&" Total")),0))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sarah (OGI)" wrote in message
...
I have a spreadsheet with the following formula in cell L35:

=IF(B35="","",IF(ISERROR(GETPIVOTDATA('LOST MEMBERS PIVOT
TABLE'!A33,Calculator!$B35&" Total")),"£0",GETPIVOTDATA('LOST MEMBERS
PIVOT
TABLE'!A33,Calculator!$B35&" Total")))

I've formatted the cell so it shows zero decimal places and the result
appears as -11. However, I noticed a problem whereby this result does not
match the value in K35 (which has been put in place to manually calculate
the
relevant cells to check that L35 is correct), so when this value is copied
into another cell, via paste special (values), the actual value is:
-11.1000000000001

Any ideas why this is? I think I may need to have the formula
=round(L35,2), but is there any way to include this in the original
formula
detailed above?