rounding decimal places

[Cherie QLD]

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.

 

[T. Valko]

Try this:

A1 = 1825.27

=ROUND(A1/0.05,0)*0.05

 

[Teethless mama]

=MROUND(A1,0.05)

 

[Cherie QLD]

Thanks very much T. Valko - it was driving me nuts! Improves productivity at
my desk no end

Cherie

 

[T. Valko]

You're welcome. Thanks for the feedback!