rounding currency amounts
 

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

rounding currency amounts
 

Try using the CEILING Function.
Micky


"sruarg" wrote:

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

rounding currency amounts
 

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

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

"sruarg" wrote:

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

rounding currency amounts
 

On Wed, 13 Jan 2010 13:13:01 -0800, sruarg
wrote:

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

rounding currency amounts
 

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

"Jeff Jensen" wrote:

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

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

"sruarg" wrote:

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