Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personale Number Rounding!!!!!
Hello!! I have to make rounding on some numbers but the rule of my roundin would be these: 1)if the number has the value "4" in the 3rd decimal position leave th number rounded on second decimal. Example if number is 8932,2341 the rounded number would be 8932,23. 2)if the number has the 3rd decimal position greater than "4", roun off for excess. Example if number is 62725,1591 the rounded numbe would be 62725,16. I don't know how make this in excel because the default roundin doesn't work with specifical number on a specifical decimal position Someone can tell me how solve this problem???!?! ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to every 5th whole number | Excel Discussion (Misc queries) | |||
Rounding number to 0.25 ? | Excel Discussion (Misc queries) | |||
number rounding | Excel Worksheet Functions | |||
How do I keep a value from rounding up to the next number? | Excel Worksheet Functions | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |