Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding numbers
in one spreadsheet I get total of $96,897.33 and using the same exact figures
in another spreadsheet, I get $96,897.32 and the penny is driving me off the deep end. Why are the spreadsheets off .01 cent? Must I round down or up? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding numbers
From J.E. McGimpsey's web site:
http://www.mcgimpsey.com/excel/pennyoff.html -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Excel Wired" <Excel wrote in message ... in one spreadsheet I get total of $96,897.33 and using the same exact figures in another spreadsheet, I get $96,897.32 and the penny is driving me off the deep end. Why are the spreadsheets off .01 cent? Must I round down or up? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding numbers
What are the formulae in the 2 spreadsheets?
What are the data values in the 2 spreadsheets? Do you have different options set (such as precision as displayed)? Whether you should round up or down (or neither) depends on what calculation you are trying to do. -- David Biddulph "Excel Wired" <Excel wrote in message ... in one spreadsheet I get total of $96,897.33 and using the same exact figures in another spreadsheet, I get $96,897.32 and the penny is driving me off the deep end. Why are the spreadsheets off .01 cent? Must I round down or up? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding numbers
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers | Excel Discussion (Misc queries) | |||
Rounding Numbers. | Excel Worksheet Functions | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Rounding up numbers up or down. | Excel Worksheet Functions | |||
Rounding Numbers | Excel Discussion (Misc queries) |