Use Of INT
Number
|
Integer
| |
1.5
|
1
|
=INT(C4)
|
2.3
|
2
|
=INT(C5)
|
10.75
|
10
|
=INT(C6)
|
-1.47589
|
-2
|
=INT(C7)
|
What Does It Do ?
This function rounds a number down to the nearest whole number.
Syntax
=INT(Number)
Formatting
No special formatting is needed.
Example
The following table was used by a school to calculate the age a child when the
school year started.
A child can only be admitted to school if they are over 8 years old.
The Birth Date and the Term Start date are entered and the age calculated.
Table 1 shows the age of the child with decimal places
Table 1
| |||
Birth Date
|
Term Start
|
Age
| |
01-Jan-80
|
01-Sep-88
|
8.668035592
|
=(D27-C27)/365.25
|
05-Feb-81
|
01-Sep-88
|
7.570157426
| |
20-Oct-79
|
01-Sep-88
|
8.8678987
| |
01-Mar-81
|
01-Sep-88
|
7.504449008
|
Table 2 shows the age of the child with the Age formatted with no decimal places.
This has the effect of increasing the child age.
Table 2
| |||
Birth Date
|
Term Start
|
Age
| |
01-Jan-80
|
01-Sep-88
|
9
|
=(D38-C38)/365.25
|
05-Feb-81
|
01-Sep-88
|
8
| |
20-Oct-79
|
01-Sep-88
|
9
| |
01-Mar-81
|
01-Sep-88
|
8
|
Table 3 shows the age of the child with the Age calculated using the =INT() function to
remove the decimal part of the number to give the correct age.
Table 3
| |||
Birth Date
|
Term Start
|
Age
| |
01-Jan-80
|
01-Sep-88
|
8
|
=INT((D49-C49)/365.25)
|
05-Feb-81
|
01-Sep-88
|
7
| |
20-Oct-79
|
01-Sep-88
|
8
| |
01-Mar-81
|
01-Sep-88
|
7
|
Note
The age is calculated by subtracting the Birth Date from the Term Start to find the
age of the child in days.
The number of days is then divided by 365.25
The reason for using 365.25 is to take account of the leap years.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें