| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Round up to nearest whole number at a specific decimal?
I have been bouncing this around a few days and I can't seem to get it.
What I need is a formula that will round a cell up to the next whole number at a specified decimal, and down below that decimal. example A1=480 B1=A1/350 - Result = 1.3714... I need this example to round up at 0.1428 and down at 0.1427, in this case result would be "2" Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round time to nearest 15 minutes in decimal format | Excel Discussion (Misc queries) | |||
| How can you round a number to the nearest 900? | Excel Discussion (Misc queries) | |||
| How do I round a number to the nearest 900? | Excel Discussion (Misc queries) | |||
| How can you round a number to the nearest 900? | Excel Worksheet Functions | |||
| Round a decimal to the nearest sixteenth | Excel Programming | |||
Threaded Mode
