Solved

round whole integer number in excel

Posted on 2013-05-27
2
420 Views
Last Modified: 2013-05-28
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
0
Comment
Question by:drtopserv
2 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 250 total points
ID: 39198976
=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
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 250 total points
ID: 39198984
Hi,

Or
 =CEILING(A1,500)

Regards
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now