Access 2007-2019 Access 2000-2003 Access Seminars TechHelp Support Tips & Tricks Access Forum Course Index Topic Glossary Insider Circle

 Home   News   Courses   Tips   Templates   Forums   Help   Order   Contact   Logon More... What's New? Tips & Tricks Access Index Access Tips Excel Index Excel Tips Waiting List

# Round Int Fix

Rounding Numbers with Round, Int, and Fix

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

 You may want to read these articles from the 599CD News:
 8/13/2020 CopyFileA Function 8/13/2020 Access Turn Off Warnings 8/13/2020 MsgBox Prompt Yes No Cancel 8/12/2020 Navigation Pane Minimize Restore 8/12/2020 Ribbon Minimize and Restore 8/12/2020 Application Window Maximize Restore 8/12/2020 Access VBA 8/12/2020 Free Beginner Courses 8/11/2020 Access Maximize App Window 8/10/2020 Access Beginner Courses

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Account Login Online Theater Downloads Lost Password Free Upgrades Insider Circle Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Articles Search The Site Waiting List Production Schedule Collapse Menus Help  Live Chat Customer Support WalkThru Tutorials Troubleshooting FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks MYOLP Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Live Chat General Info Support Policy Contact Form Email Richard Mailing Address Phone Number Fax Number Course Survey