Rounding up values

S

Sarah (OGI)

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?
 
B

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top