| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round to nearest whole number
Upon dividing one cell by another, I want to store the result in a variable
that is rounded to the nearest whole number (6.5 = 7, 6.2 = 6, etc.). My basic formula is: NamesPerSlip = ActiveCell.Offset(0, -3) / ActiveCell.Offset(0, -2) Rounding NamesPerSlip up or down as needed is my challenge. Thanks as always! -- Steve C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number to the Nearest .25 | Excel Worksheet Functions | |||
| Round Number to Nearest 50 | 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 | |||
Threaded Mode
