Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down
I am working on an excel spread sheet running price costing numbers. I want
the numbers to round up to multiplies ending in 5 or 0. Example if I have a cost of $ 122.18, I need to round to 120.00 if the the number is 124.88 I need the number to round up 125.00. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
ROUNDING UP | New Users to Excel | |||
Rounding down | Excel Worksheet Functions | |||
rounding | Excel Discussion (Misc queries) |