Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would really like some help,
round(3348.86*.1,2) = 334.89 round(3348.86*.03,2) = 100.47 when added together 334.89+100.47 = 435.36 yet round(3348.86*.13,2) = 435.35 I beleive it is because 100.4658 is rounding to 100.47, when it should be 100.46. I really need these numbers to add up. If this is possible it would be great. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unwanted rounding of large number | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |