INT rounds of the number to lowest and nearest whole number. INT function does not require any special formatting.
Syntax: INT(Number)
| Number | Integer | Formula |
| 3.5 | 3 | =INT(3.5) |
| 7.2 | 7 | =INT(7.2) |
| 15.99 | 15 | =INT(15.99) |
| -22.7925 | -23 | =INT(-22.7925) |
Example: A competitive exams require the 18 years of age to appear in exams. Here is example on finding candidate with age over 18.
Click on image to view enlarge
I have uploaded the MS Excel file with INT function and INT function example to ensure that we don't miss anything with respect to basic understanding of INT function.
Also, do let me know your comments about this post and subscribe to us to receive latest updates via email
We assure you knowledge, not SPAM!
2 comments:
This blog really enhances my excel knowledge. Furthuremore Sarfaraz always helps group members with their excel related doubts. Sharing of problems and solutions by group members helped me a lot. Thanks a lot Sarfaraz.
This blog really helps us in enhancing our excel knowledge. Furthuremore Sarfaraz always go out of way to help members of the blog. Great work.
Post a Comment