rounding up currency

  • Thread starter Thread starter larry
  • Start date Start date
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!!
 
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.
 
Back
Top