Thread
:
rounding decimal places
View Single Post
#
2
Posted to microsoft.public.excel.misc
T. Valko
external usenet poster
Posts: 15,768
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.
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko