rounding currency amounts

  • Thread starter Thread starter sruarg
  • Start date Start date
S

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
 
Next five cents:
=ROUNDUP(A1/0.05,0)*0.05

Nearest five cents:
=ROUND(A1/0.05,0)*0.05
 
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
Click to expand...

Try this formula:

=MROUND(A1+0.2499, 0.05)

Hope this helps / Lars-Åke
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locked spreadsheet, without cents 1
Is there a way to round currency? 1
News Bank of England considers digital currency 4
Rounding to the nearest cent...currency values 3
how to multiply two values and round the result 5
Formatting Currency Without Any Special Characters 3
How do I round down currency in Excell? 2
Converting amount($) of my expenditure into the base currency i wa 1

Back
Top