Excel function - Rounding currency

M

Marrick

Is there a way of rounding to the nearest 5 cents?
eg $12.44 would round to $12.45
$12.42 would round to $12.40.
Much appreciate any help with this
 

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 Function 5
How do I correct rounding errors in Excel formulas? 1
rounding formulas 2
rounding figures to nearest thousand 3
rounding the results of two times 5
Need help in rounding answers to nearest multiple 6
Rounding to Nearest 250 6
Rounding Up question 2

Top