Mathematical Function
SUM( ):- Adds a series of numbers.
Syntax:
=SUM(number1, number2, ...)
Example-
=SUM(A1:A5)
Adds
values from cell A1 to A5.
✅ 2. AVERAGE()
Calculates
the average (arithmetic mean).
Syntax:
excel
CopyEdit
=AVERAGE(number1, number2,
...)
Example:
excel
CopyEdit
=AVERAGE(B1:B5)
Gives
average of values in B1 to B5.
✅ 3. ROUND()
Rounds
a number to a specified number of digits.
Syntax:
excel
CopyEdit
=ROUND(number, num_digits)
Example:
excel
CopyEdit
=ROUND(12.3456, 2)
Returns
12.35.
✅ 4. INT()
Rounds
a number down to the nearest integer.
Syntax:
excel
CopyEdit
=INT(number)
Example:
excel
CopyEdit
=INT(5.9)
Returns
5.
✅ 5. MOD()
Returns
the remainder after a number is divided by a divisor.
Syntax:
excel
CopyEdit
=MOD(number, divisor)
Example:
excel
CopyEdit
=MOD(10, 3)
Returns
1.
✅ 6. POWER() or ^
Raises
a number to a power.
Syntax:
excel
CopyEdit
=POWER(number, power)
Example:
excel
CopyEdit
=POWER(2, 3)
Returns
8 (2³).
Or
simply:
excel
CopyEdit
=2^3
✅ 7. SQRT()
Returns
the square root of a number.
Syntax:
excel
CopyEdit
=SQRT(number)
Example:
excel
CopyEdit
=SQRT(25)
Returns
5.
✅ 8. ABS()
Returns
the absolute (positive) value of a number.
Syntax:
excel
CopyEdit
=ABS(number)
Example:
excel
CopyEdit
=ABS(-10)
Returns
10.
✅ 9. PRODUCT()
Multiplies
numbers together.
Syntax:
excel
CopyEdit
=PRODUCT(number1, number2,
...)
Example:
excel
CopyEdit
=PRODUCT(A1:A3)
Multiplies
all numbers from A1 to A3.
✅ 10. QUOTIENT()
Returns
only the integer portion of a division.
Syntax:
excel
CopyEdit
=QUOTIENT(numerator,
denominator)
Example:
excel
CopyEdit
=QUOTIENT(10, 3)
Returns
3.
✅ 11. CEILING() / FLOOR()
Rounds
a number up/down to the nearest specified multiple.
Syntax:
excel
CopyEdit
=CEILING(number,
significance)
=FLOOR(number, significance)
Example:
excel
CopyEdit
=CEILING(17, 5) → 20
=FLOOR(17, 5) → 15
✅ 12. RAND() and RANDBETWEEN()
Generates
random numbers.
Syntax:
excel
CopyEdit
=RAND() → returns a decimal
between 0 and 1
=RANDBETWEEN(bottom, top)
Example:
excel
CopyEdit
=RANDBETWEEN(1, 100)
Returns
a random integer between 1 and 100.
✅ 13. COUNT() and COUNTA()
Counts
cells with numbers or non-blank entries.
Syntax:
excel
CopyEdit
=COUNT(range)
=COUNTA(range)
Example:
excel
CopyEdit
=COUNT(A1:A10) → only
numbers
=COUNTA(A1:A10) → all
non-empty cells
✅ 14. SUBTOTAL()
Returns
a subtotal in a filtered list.
Syntax:
excel
CopyEdit
=SUBTOTAL(function_num,
range)
Example:
excel
CopyEdit
=SUBTOTAL(9, A1:A10)
Function
9 = SUM → sums only visible cells.
✅ 15. IF() with Math
Syntax:
excel
CopyEdit
=IF(condition,
value_if_true, value_if_false)
Example:
excel
CopyEdit
=IF(A1>100, A1*10%,
A1*5%)
Applies
10% if value >100, else 5%.
.png)
0 Comments