rounding decimal places

C

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.
 
C

Cherie QLD

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

Cherie
 
Top