Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
SUMPRODUCT rounding up values | Excel Worksheet Functions | |||
Rounding | New Users to Excel | |||
rounding values in in array before sum | Excel Worksheet Functions | |||
Stop rounding values | Excel Worksheet Functions |