Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Tips & Tricks New Tips Added Weekly! Click here to get on our Mailing List

# Round Int Fix

Rounding Numbers with Round, Int, and Fix

UPDATE: see my NEW video: Rounding

Q: I have a situation where I need to round a number UP to the next whole integer, but the ROUND function brings it to the nearest integer. For example, I need 4.2 rounded UP to 5. How can I do this?

A: There are three functions you should be familiar with when it comes to rounding numbers. The first is the ROUND function. This will round off any decimal number to the nearest integer. Anything over .5 will be rounded up. So 4.1 becomes 4, and 4.8 becomes 5.

Next you have the INT function. This rounds any decimal number DOWN to the nearest integer. So 4.1 becomes 4, and 4.8 is also 4.

Finally you have the FIX function which rounds POSITIVE numbers DOWN to the nearest integer, but rounds NEGATIVE numbers UP. So 4.1 becomes 4, and 4.8 becomes 4, but -4.1 becomes -5. The difference between INT and FIX is simply how they handle negatives.

You can generate these values in a query simply by creating calculated fields:

So to answer your question, if you always want to round a value UP to the next integer, I would use INT(x)+1. This will use the INT function to bring your value DOWN to the nearest integer. Then just add 1 to it.

By Richard Rost
Click here to sign up for more FREE tips

 You may want to read these articles from the 599CD News:
 8/17/2022 Append Mistake #2 8/15/2022 Interview Questions 8/15/2022 Append Mistake #1 8/14/2022 Hex to RGB 8/12/2022 Transpose Data 8/11/2022 Crosstab 8/9/2022 Append Query 8/8/2022 Indexing 8/5/2022 No Data 8/4/2022 Secondary Emails

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Login My Account My Courses Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey