Rounding up to nearest 5cents

[Greg]

How do I Round up to nearest 5cents?

 

[Norman Harker]

Hi Greg!

Try:

=ROUNDUP(A1/0.05,0)*0.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.

 

[JE McGimpsey]

One way:

=CEILING(A1,0.05)

another:

=ROUNDUP(A1*20,0)/20

 

[Guest]

Thanks so much. Easy when you know how!
Greg

-----Original Message-----
One way:

=CEILING(A1,0.05)

another:

=ROUNDUP(A1*20,0)/20


.