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.

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.

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.

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.

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.