Can I round to the nearest nickel@

S

Steve

I would like to use the ROUND function to round a currency
number to the nearest nickel (0.05). Any examples?
 
P

Peo Sjoblom

=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)
 
C

CoRrRan

I would like to use the ROUND function to round a currency
number to the nearest nickel (0.05). Any examples?
Click to expand...

=ROUND(A1/0.05;0)*0.05

Any good?

CoRrRan
 

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
rounding a number up to a certain ending digit 6
Round to .05 or .09 4
Round Question 3
Rounding Time to Nearest 5 Minutes 1
rounding numbers to the nearest dollar amount 11
rounding up to the nearest 1000 1

Top