Rounding to nearest $500 or $1000 in Excel

  • Thread starter Norie Sutherland
  • Start date
N

Norie Sutherland

Anyone know how to set a cell up to round automatically to the nearest $500
or $1000? (e-mail address removed)
 
K

Ken Wright

=ROUND(A1,-3) For 1000s
=MROUND(A1,1000) For 1000s
=ROUND(A1*2,-3)/2 For 500s
=MROUND(A1,500) For 500s

MROUND requires Analysis Toolpak installed
 

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

Rounding Functions 5
Format cell to the nearest 100 4
Rounding up to nearest 500 5
How to use Ceiling to round? 11
advice on rounding or ceilng a 24 hour time value 3
Rounding 4
Access Running Balance in Access 1
rounding up to nearest specified whole number 1

Top