int

 Excel offers a variety of functions to work with integers and perform calculations. Below is a list of 10 commonly used Excel functions related to integers, along with examples of how to use them:

---

1. INT Function

• Purpose: Rounds a number down to the nearest integer.

• Formula: =INT(number)

• Example: =INT(8.9) returns 8.

---

2. ROUND Function

• Purpose: Rounds a number to a specified number of digits.

• Formula: =ROUND(number, num_digits)

• Example: =ROUND(3.14159, 2) returns 3.14.

---

3. ROUNDUP Function

• Purpose: Rounds a number up to a specified number of digits.

• Formula: =ROUNDUP(number, num_digits)

• Example: =ROUNDUP(5.123, 2) returns 5.13.

---

4. ROUNDDOWN Function

• Purpose: Rounds a number down to a specified number of digits.

• Formula: =ROUNDDOWN(number, num_digits)

• Example: =ROUNDDOWN(5.789, 2) returns 5.78.

---

5. MOD Function

• Purpose: Returns the remainder after division.

• Formula: =MOD(number, divisor)

• Example: =MOD(10, 3) returns 1 (since 10 divided by 3 leaves a remainder of 1).

---

6. CEILING Function

• Purpose: Rounds a number up to the nearest multiple of significance.

• Formula: =CEILING(number, significance)

• Example: =CEILING(7.2, 1) returns 8.

---

7. FLOOR Function

• Purpose: Rounds a number down to the nearest multiple of significance.

• Formula: =FLOOR(number, significance)

• Example: =FLOOR(7.8, 1) returns 7.

---

8. TRUNC Function

• Purpose: Truncates a number to an integer by removing the fractional part.

• Formula: =TRUNC(number, [num_digits])

• Example: =TRUNC(9.99) returns 9.

---

9. EVEN Function

• Purpose: Rounds a number up to the nearest even integer.

• Formula: =EVEN(number)

• Example: =EVEN(3.2) returns 4.

---

10. ODD Function

• Purpose: Rounds a number up to the nearest odd integer.

• Formula: =ODD(number)

• Example: =ODD(4.1) returns 5.

---

Example Data and Formulas in a Table:

Number	Formula	Result
8.9	=INT(A2)	8
3.14159	=ROUND(A3, 2)	3.14
5.123	=ROUNDUP(A4, 2)	5.13
5.789	=ROUNDDOWN(A5, 2)	5.78
10	=MOD(A6, 3)	1
7.2	=CEILING(A7, 1)	8
7.8	=FLOOR(A8, 1)	7
9.99	=TRUNC(A9)	9
3.2	=EVEN(A10)	4
4.1	=ODD(A11)	5

---

These functions are useful for various mathematical operations and data manipulation tasks in Excel.