rounding currency amounts

[sruarg]

i would like to round a currency amount to the next $ 0.05 (five cents)

eg 30.63 to be 30.65 or 40.48 to be 40.50

 

[מיכ×ל (מיקי) ×בידן]

Try using the CEILING Function.
Micky

 

[Jeff Jensen]

Next five cents:
=ROUNDUP(A1/0.05,0)*0.05

Nearest five cents:
=ROUND(A1/0.05,0)*0.05

 

[Lars-Åke Aspelin]

i would like to round a currency amount to the next $ 0.05 (five cents)

eg 30.63 to be 30.65 or 40.48 to be 40.50

Try this formula:

=MROUND(A1+0.2499, 0.05)

Hope this helps / Lars-Åke

 

[Jeff Jensen]

I forgot something...

Next five cents:
=ROUNDUP(A1/0.05,0)*0.05
=CEILING(A1,0.05)

Nearest five cents:
=ROUND(A1/0.05,0)*0.05