Solved

round whole integer number in excel

Posted on 2013-05-27
2
443 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 49

Accepted Solution

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

Or
 =CEILING(A1,500)

Regards
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel 2010 - Delete Row based on date 8 34
MS excel check if Links exist 5 35
Excel - Data Validation 3 25
Excel error  #DIV/0! 7 17
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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