Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






Excel Math Functions : INT

How to use INT Math Functions in Microsoft Excel

Introduction to INT Function

INT function returns the integer part of a decimal number. In simple words, it rounds down the number by removing its decimals and returns only the integer part of the number.

Download Sample file

Download Sample file for working with the tutorial.

Syntax of INT Function

INT(number)

Arguments in INT Function

  • number: Number you want to round down to the nearest integer.

Notes

  • It will round down both positive or negative numbers.

Tutorial of INT Function in MS Excel

In the below example, we have rounded 9.9 to 9 and 8.9 to 8. You can use this rounding function to remove decimals from the numbers.

In the example above, the result will be 2.

Other Math Function in Microsoft Excel

Explore other math function in Microsoft excel. The list of all the math function available for everyday use is given below –

Content

Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes