Home Application Office information

The INT (Function rounds a number down to the nearest integer of a number) in Excel

The INT function helps you get the integers of a number, often used to process the result of a division in Excel.

Table of Contents

The INT function helps you get the integers of a number, often used to process the result of a division in Excel.

Picture 1 of The INT (Function rounds a number down to the nearest integer of a number) in Excel

If you do not know about INT function, you follow the article below to know the syntax and usage of the INT function.

Description

The INT function rounds a number down to the nearest integer of a number (or a division multiplication operation).

Syntax

= INT (number)

Inside:

- number: real number, or a division multiplication operation that you want to round down to integers, required parameters.

For example

- number is a real number.

Example 1:

Picture 2 of The INT (Function rounds a number down to the nearest integer of a number) in Excel

Example 2:

Picture 3 of The INT (Function rounds a number down to the nearest integer of a number) in Excel

- number is a division multiplication operation.

Example 3:

Picture 4 of The INT (Function rounds a number down to the nearest integer of a number) in Excel

The syntax and usage of the INT function is very simple, you can combine it with other functions in Excel to process data more efficiently. Good luck!

You've just finished reading the article "The INT (Function rounds a number down to the nearest integer of a number) in Excel" edited by the TipsMake team. You can save the-int-function-rounds-a-number-down-to-the-nearest-integer-of-a-number-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : The Match function...
Find, FindB... : NEXT »
Read more