| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roundup or Ceiling Function to round to a specific number
Does anyone know how to use the Round Function or the Ceiling function to
round up to a specific number? Example: I have the number 1288 in D8 and I have a formula in E8 which says =D8/0.67, the result is 1922. But I would like 1922 to round up to 1925. Had it been 1927, I would want it to round up to 1929. Can anyone tell me how to do this? -- Angie33 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round up to next half number | New Users to Excel | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions | |||
| Round a number in nested function | Excel Worksheet Functions | |||
| Change a number to round up without a function | Excel Discussion (Misc queries) | |||
Threaded Mode
