Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am having trouble getting either a product or sum to round to the nearest
cent. How do I do this? Example 6015.54x1.4=8421.76, However when I do this in excel, it ends up being 8421.75 for some reason. Or if I choose to add 6015.54 and 2406.22 (the latter a result of multiplying the former by .4) it still gives me 8421.75...the actual calculation works out to 8421.756, so obviously it is just dropping the last number (or rounding it down to the nearest fifth one hundredth?)...I'd prefer seeing as how I am working with currency that it rounded the final number appropriately. Help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rounding to nearest 100 | Excel Worksheet Functions | |||
Rounding to the nearest 5 | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Currency Rounding to nearest 5 cents | Excel Discussion (Misc queries) | |||
rounding to 25 cent incriments | Excel Discussion (Misc queries) |