| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use Ceiling to round?
Can anyone help me with a rounding issue
I have a formula that looks like this F7*F27 16,995*.92134 = 15,658.17 I then need to Round to the nearest 500 and then subtract 5 15,659 rounded to the neares is 15,500 then subtract 5 = 15,495 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MOD and Ceiling formula used to round up and down to 49 and 99 | Excel Discussion (Misc queries) | |||
| Roundup or Ceiling Function to round to a specific number | Excel Discussion (Misc queries) | |||
| ceiling | Excel Discussion (Misc queries) | |||
| Round/Ceiling on an IF function returning numerical value or text | Excel Worksheet Functions | |||
| Max, Ceiling, If, Etc | Excel Discussion (Misc queries) | |||
Threaded Mode
