Sponsored Link

There was an error in this gadget

Sponsored Link

Saturday, May 16, 2009

INT function

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

INTFUNCTION

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

INT function Example

We assure you knowledge, not SPAM!

2 comments:

kundandalvi@gmail.com said...

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.

kundandalvi@gmail.com said...

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