| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
Hi
I want to use (I think it's called) bankers rounding on a number. What I want to do is round to the nearest whole million. So if I have 9 700 000 then it should be 10 000 000 1 500 000 then it should be 2 000 000 3 499 000 then it should be 3 000 000 if there any function in excel to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Percentage rounding error in charts | 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) | |||
Threaded Mode
