rounding up currency

L

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!!
 
N

Norman Harker

Hi Larry!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top