Mastering INT() in ExcelOverview, Examples, and Assignments for Beginners
INT() Function in Excel
The INT() function in Microsoft Excel is used to round a number down to
the nearest integer. This function is particularly useful when you need to
discard the decimal portion of a number without rounding it up.
Syntax
The syntax of the INT() function is:
INT(number)
- number: This is the numeric value
that you want to round down to the nearest integer. It can be a cell
reference, a constant, or a formula that returns a numeric value.
How the INT() Function Works
- The INT() function takes a
single argument (the number) and returns the largest integer that is less
than or equal to that number.
- If the number is already an
integer, it returns the number itself.
- If the number is negative,
INT() will round it down (i.e., towards negative infinity).
Examples
Let’s look at some practical examples of how the INT() function works:
1. Positive Numbers
o Formula: =INT(7.89)
o Result: 7
o Explanation: The function rounds
down 7.89 to 7.
2. Negative Numbers
o Formula: =INT(-3.14)
o Result: -4
o Explanation: The function rounds
-3.14 down to -4, which is the largest integer less than -3.14.
3. Whole Numbers
o Formula: =INT(15)
o Result: 15
o Explanation: Since 15 is already
an integer, the function returns 15.
4. Using a Cell
Reference
o Suppose cell A1
contains the value 9.75:
o Formula: =INT(A1)
o Result: 9
o Explanation: The function rounds
down the value in A1 (9.75) to 9.
5. Rounding Down to
Nearest Whole Number
o Formula: =INT(12.999)
o Result: 12
o Explanation: The function rounds
down 12.999 to 12.
Practical Applications
The INT() function has several practical applications in business and
data analysis, including:
1. Calculating Discounts: When applying
discounts to products, you might want to round down to the nearest integer to
avoid dealing with fractions of a currency unit.
2. Inventory Management: When counting
items, you can use INT() to ensure that you only account for complete units.
3. Financial Analysis: In financial
reports, rounding down can help provide conservative estimates for revenue or
expenses.
Summary
The INT() function is a straightforward and effective tool in Excel for
rounding numbers down to the nearest integer. Understanding how to use this
function can help MBA students manage and analyze numerical data more
effectively.
Additional Tips
- Be cautious when using the
INT() function with negative numbers, as it rounds down towards negative
infinity.
- Practice using the INT()
function with different types of numbers to see how it behaves in various
scenarios.
Assignments
Assignment 1: Rounding Down Prices
Objective: Round the following product prices down to the nearest integer.
Data:
|
Product
Name |
Price |
|
Product
A |
29.99 |
|
Product
B |
15.89 |
|
Product
C |
9.49 |
|
Product
D |
34.75 |
|
Product
E |
5.99 |
Instructions: Use the INT() function to round each price down to the nearest integer.
Solution:
1. For Product A (Price: 29.99):
=INT(29.99) → 29
2. For Product B (Price: 15.89):
=INT(15.89) → 15
3. For Product C (Price: 9.49):
=INT(9.49) → 9
4. For Product D (Price: 34.75):
=INT(34.75) → 34
5. For Product E (Price: 5.99):
=INT(5.99) → 5
Assignment 2: Rounding Down Scores
Objective: Round the following student scores down to the nearest integer.
Data:
|
Student
Name |
Score |
|
John |
88.75 |
|
Jane |
91.49 |
|
Mark |
72.99 |
|
Lucy |
85.50 |
|
Paul |
63.10 |
Instructions: Use the INT() function to round each score down to the nearest
integer.
Solution:
1. For John (Score: 88.75):
=INT(88.75) → 88
2. For Jane (Score: 91.49):
=INT(91.49) → 91
3. For Mark (Score: 72.99):
=INT(72.99) → 72
4. For Lucy (Score: 85.50):
=INT(85.50) → 85
5. For Paul (Score: 63.10):
=INT(63.10) → 63
Assignment 3: Rounding Down Inventory Counts
Objective: Round the following inventory counts down to the nearest whole number.
Data:
|
Item |
Count |
|
Item A |
23.75 |
|
Item B |
47.50 |
|
Item C |
55.99 |
|
Item D |
99.99 |
|
Item E |
32.10 |
Instructions: Use the INT() function to round each inventory count down to the
nearest whole number.
Solution:
1. For Item A (Count: 23.75):
=INT(23.75) → 23
2. For Item B (Count: 47.50):
=INT(47.50) → 47
3. For Item C (Count: 55.99):
=INT(55.99) → 55
4. For Item D (Count: 99.99):
=INT(99.99) → 99
5. For Item E (Count: 32.10):
=INT(32.10) → 32
Assignment 4: Rounding Down Financial Figures
Objective: Round the following financial figures down to the nearest integer.
Data:
|
Financial
Figure |
|
123.456 |
|
78.989 |
|
55.555 |
|
10.004 |
|
3.14159 |
Instructions: Use the INT() function to round each financial figure down to the nearest integer.
Solution:
1. For 123.456:
=INT(123.456) → 123
2. For 78.989:
=INT(78.989) → 78
3. For 55.555:
=INT(55.555) → 55
4. For 10.004:
=INT(10.004) → 10
5. For 3.14159:
=INT(3.14159) → 3
_________________________________________
