Can I round to the nearest nickel@

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I would like to use the ROUND function to round a currency
number to the nearest nickel (0.05). Any examples?
 
=ROUND(B1/0.05,0)*0.05

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

How do I get a calculated amount to round to the nearest nickel? 3
how do I round up to the nearest nickel? 2
Formula for rounding a column of currency to a multiple 1
Rounding a number to the nearest nickel 10
Rounding currency. 3
rounding numbers to the nearest dollar amount 11
Round to .05 or .09 8
rounding up to the nearest 1000 1

Back
Top