Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I correct rounding errors in Excel formulas?
I am working with spreadsheets in Excel 2000 and Excel 2002, and find that
although I'm using the same formulas throughout differing cells in the spreadsheet, some cells round the results correctly and some do not. Has anyone encountered this problem, and if so, does anyone know of a fix for it? The data I'm working with rounds answers that result in currency (dollars and cents) and it's imperative that I get the numbers to round correctly to the next penny following the standard rule of up for .5 cents or more and down for .4 cents or less. I have even tried copying and pasting the formulas from cells that are rounding the results correctly into the cells that are rounding incorrectly to no avail. No matter what I've tried, some cells will round correctly (in both up or down directions) and some will not (they truncate the answer instead of rounding it). Thanks in advance for any help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I correct rounding errors in Excel formulas?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Excel formulas between sheets | Excel Worksheet Functions | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel Form File Errors | Excel Discussion (Misc queries) | |||
Provide a way to turn off auto-checking excel formulas as I type t | Excel Discussion (Misc queries) | |||
Excel Error when copying formulas | Excel Worksheet Functions |