INT function

This function will rounds a number down to the nearest integer.

Syntax

INT(Number)

  • Number (required) – This is the number you want to round down to the nearest integer.

Example

In this example find the round down a few numbers. Text values will result in a #VALUE! error.

=INT(A2)

INT

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Subscribe for awesome Microsoft Excel videos 😃

👉 Find out more about our Advanced Formulas course!

Top Posts

Related Posts

Browse All

ABS function

Jun 17, 2016

This function will return the absolute value of a number. The absolute value...

read more

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃