| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
rounding numbers, with-out decimals. IE:4507 to 4510
I am trying to convert numbers to roundup and also to rounddown depending on
5. I thought maybe I can use the "=IF(C4(____5),rounddown,roundup), now I know I am not an Excel guru, as you can see, I have trouble just putting the IF THEN formula here. So how I have a script to change, oh say around 100K entries to a rounded numeral. Again no decimals are being used, I want 4507 to 4510 and 4503 to 4500. Thank you rollingover22 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding Numbers | Excel Discussion (Misc queries) | |||
| Converting imported numbers to decimals (rather than /100) | Excel Worksheet Functions | |||
| How do I stop rounding numbers? | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Threaded Mode
