| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding Up Kinda
I am trying to get the following number to round up 541387.4945
"=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| 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
