Rounding

  • Thread starter Thread starter DollarBill
  • Start date Start date
D

DollarBill

I'm trying to round to the nearest nickel.

I have looked at the round function but can't seem to get it to work.

E.g. If it's .38, the display is .40. If it's 1.32, it's 1.30.

Thanks,
Bill
 
I'm trying to round to the nearest nickel.

I have looked at the round function but can't seem to get it to work.

E.g. If it's .38, the display is .40. If it's 1.32, it's 1.30.

Thanks,
Bill
Click to expand...

=ROUND(A1/0.05,0)*0.05

--ron
 
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

Round up to nearest 25 or 50? 8
Rounding 4
ROUNDING 9
How do I get a calculated amount to round to the nearest nickel? 3
Rounding 5
Rouding at thousands 4
Rounding Formula 3
rounding help 6

Back
Top