round whole integer number in excel

Hi,
How can i round whole number in excel in such a way like this:

if the number between :  1-499  then round to 500
if the number is             :    500  then round to 500
if the number between :  501-999  then round to 1000
drtopservAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

Or
 =CEILING(A1,500)

Regards
0
 
als315Connect With a Mentor Commented:
=IF(A1>500,1000,500)
if you like formula for digits > 1000 in step 500, you can use:
=INT((A1-1)/500+1)*500
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.