How do I round to the nearest $5.00 in Excel? $74.03=$75

K

Ken Wright

=CEILING(A1,5)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
D

daddylonglegs

To round to the nearest $5

=MROUND(A1,5)

MROUND is part of Analysis ToolPak

an alternative is

=ROUND(A1/5,0)*
 

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

Excel: Round formula up in $5. increments =+(M4*1.1)+M4 5
Round numbers to get to the nearest 0.09 7
rounding up to the nearest 1000 1
How do I get a calculated amount to round to the nearest nickel? 3
Rounding Time to Nearest 5 Minutes 1
Round Question 3
How can I Round up to the nearest .25 11
Round Function 5

Top