rounding up currency

[larry]

I am trying to round numbers on my spreadsheet up to
currency that ends in either .00 or .05. For example,
round $1.22 to $1.25 or round $1.27 to $1.30.

Is there a way to do it? Thanks!!

 

[Norman Harker]

Hi Larry!

=ROUNDUP(A1*20,0)/20
Or
=CEILING(A1,.05)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.