| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding decimal places
is there a formula to round just the decimal place? I want to show $1825.27
as $1825.25, and not $1825. I need to round to the nearest 0 or 5. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rounding decimal places
Try this:
A1 = 1825.27 =ROUND(A1/0.05,0)*0.05 -- Biff Microsoft Excel MVP "Cherie QLD" <Cherie wrote in message ... is there a formula to round just the decimal place? I want to show $1825.27 as $1825.25, and not $1825. I need to round to the nearest 0 or 5. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rounding decimal places
=MROUND(A1,0.05)
"Cherie QLD" wrote: is there a formula to round just the decimal place? I want to show $1825.27 as $1825.25, and not $1825. I need to round to the nearest 0 or 5. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rounding decimal places
Thanks very much T. Valko - it was driving me nuts! Improves productivity at
my desk no end Cherie "T. Valko" wrote: Try this: A1 = 1825.27 =ROUND(A1/0.05,0)*0.05 -- Biff Microsoft Excel MVP "Cherie QLD" <Cherie wrote in message ... is there a formula to round just the decimal place? I want to show $1825.27 as $1825.25, and not $1825. I need to round to the nearest 0 or 5. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rounding decimal places
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Cherie QLD" wrote in message ... Thanks very much T. Valko - it was driving me nuts! Improves productivity at my desk no end Cherie "T. Valko" wrote: Try this: A1 = 1825.27 =ROUND(A1/0.05,0)*0.05 -- Biff Microsoft Excel MVP "Cherie QLD" <Cherie wrote in message ... is there a formula to round just the decimal place? I want to show $1825.27 as $1825.25, and not $1825. I need to round to the nearest 0 or 5. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set fixed Decimal places with no rounding | Excel Worksheet Functions | |||
| Rounding to two even decimal places | Excel Worksheet Functions | |||
| Rounding off decimal places | Excel Discussion (Misc queries) | |||
| Decimal Places - Settings for Auto Rounding Up/Down | Excel Worksheet Functions | |||
| Decimal places and rounding up (or down) | New Users to Excel | |||
Linear Mode
