| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding up or down
One way:
=ROUND(A1*2,-1)/2 In article , Taylor wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding up or down
=MROUND(A2,5)
Where A2 contains the value you want to round... "Taylor" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding up or down
Thanks but your answer cut my value in half.
"JE McGimpsey" wrote: One way: =ROUND(A1*2,-1)/2 In article , Taylor wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding up or down
Then you didn't enter it correctly.
In article , Taylor wrote: Thanks but your answer cut my value in half. "JE McGimpsey" wrote: One way: =ROUND(A1*2,-1)/2 |
| Reply |
| 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) | |||
Linear Mode
