Rounding up values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah (OGI) - 20 Sep 2007 11:08 GMT

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?

Reply to this Message

Bob Phillips - 20 Sep 2007 11:17 GMT

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

Signature

---
HTH

Bob

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

>I have a spreadsheet with the following formula in cell L35:
>
[quoted text clipped - 15 lines]
> formula
> detailed above?

Reply to this Message