How can I round a number to the nearest "50" or "100" in excel 200

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a odd number and would like to round it off the nearest 50 or 100
whichever is closer. Can that be done? If yes how. Thanks
 
I have a odd number and would like to round it off the nearest 50 or 100
whichever is closer. Can that be done? If yes how. Thanks
Click to expand...
Since 100 is a multiple of 50, just round to 50. It will yield the
necessary result. If the number of interest is in A1, use
=ROUND(A1/50,0)*50.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
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

Alternate Rounding Up & Down of .50 in a column 5
Rounding problems 6
rounding up to the nearest 1000 1
Round numbers to get to the nearest 0.09 7
rounding to nearest 100 2
Rounding to nearest 250 by 125s 3
Rounding Time to Nearest 5 Minutes 1
Rounding Up to the 50 4

Back
Top