Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal Places - Settings for Auto Rounding Up/Down
Three colleagues and myself regularly work on a spreadsheet containing
formulas to calculate percentages from whole numbers, and display the results to two decimal places. However, when one person updates the spreadsheet, the percentages that are returned by the forumula are sometimes 0.01% different the the percentages returned if the rest of us update the spreadsheet. Does anyone have any ideas? If so, we would be so grateful. Could the precision setting have anything to do with this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
Max decimal places | Excel Discussion (Misc queries) | |||
Decimal places and rounding up (or down) | New Users to Excel | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions |