| =ABS() | =FACT() | =EVEN() | =ODD() | =INT() |
| =ROUND() | =LOG() | =LOG10() | =SUM() | =SUMIF() |
| =SUMIFS() | =SUMPRODUCT() | =PI() | =POWER() | =PRODUCT() |
| =SIGN() | =ROMAN() | =SQRT() | =ROUNDUP() | =ROUNDDOWN() |
| =CEILING() | =FLOOR() | =MOD() |
=ABS()
This function is used to display the absolute value i.e it converts -ve to +ve value
Syntax : =ABS(-ve no.)
Ex: =ABS(-7) >> Output: 7
=FACT()
This function returns the factorial number of the given value.
Syntax : =FACT(number)
Ex: = FACT(7) >> Output: 5040 (7x6x5x4x3x2x1)
=EVEN()
This function returns the next even number of an odd number.
Syntax : =EVEN(odd number)
Ex: = EVEN(7) >> Output: 8
=ODD()
This function returns the next odd number of an even number.
Syntax : =ODD(even number)
Ex: = ODD(6) >> Output: 7
=INT()
This function returns only the integer part of the decimal number.
Syntax : =INT(decimal number)
Ex: = INT(7.18) >> Output: 7
=ROUND()
This function display the number of decimal places of the given decimal number.
Syntax : =ROUND(decimal number, number of decimal places)
Ex: = ROUND(7.1807, 2) >> Output: 7.18
=LOG()
This function returns the logarithm value of a given number with base
Syntax : =LOG(number, base)
Ex: = LOG(100,10) >> Output: 2
=LOG10()
This function returns the 10 logarithm value of a given number.
Syntax : =LOG10(number)
Ex: = LOG10(100) >> Output: 2
=SUM()
This function returns the summation value of a given numbers.
Syntax : =SUM(number / range)
Ex: =
=SUMIF()
This function returns the summation value of a given numbers on a specific condition.
Syntax : =SUMIF(range, criteria, [sum_range])
Ex-
=SUMIFS()
This function returns the summation values of a given numbers which have more than one condition.
Syntax : =SUMIFS(sum_range, criteria_range1, criteria1....)
Ex-
=SUMPRODUCT()
This function returns the grand total of two arrays.
Syntax : =SUMPRODUCT(sum_range, criteria_range1, criteria1....)
Ex-
4x5 + 6x5 + 5x6=PI()
This function returns the value of pi.
Syntax : =pi()
Output- 3.142857
=POWER()
This function returns the power of the numbers.
Syntax : =POWER(number, power)
Ex- =POWER(5,2) >> Output: 25
=PRODUCT()
This function returns the power of the numbers.
Syntax : =PRODUCT(number1, number2, .....)
Ex- =PRODUCT(5,2,5) >> Output: 50
=SIGN()
This function returns the sign value of the numbers.
if it is +ve return +1, if it is -ve return -1, if it 0 return 0
Syntax : =SIGN(number)
Ex- =SIGN(10) && =SIGN(10) >> Output: +1 -1
=ROMAN()
This function converts the number to the roman number.
Syntax : =ROMAN(number)
Ex- =ROMAN(5) >> Output: V
=SQRT()
This function returns the square root of given number.
Syntax : =SQRT(number)
Ex- =SQRT(25) >> Output: 5
=ROUNDUP()
This function returns the round the nearest decimal value of the given decimals.
Syntax : =ROUNDUP(decimal no., significance)
Ex- =ROUNDUP(135.525, 0) >> Output: 136
=ROUNDDOWN()
This function returns the round the previous decimal value of the given decimals.
Syntax : =ROUNDDOWN(decimal no., significance)
Ex- =ROUNDDOWN(135.525, 0) >> Output: 135
=CEILING()
This function round the decimal no. to the next and near the int. no.
Syntax : =CEILING(decimal no., significance)
Ex- =CEILING(15.67, 1) >> Output: 16
=FLOOR()
This function round the decimal no. the previous and near the int. no.
Syntax : =FLOOR(decimal no., significance)
Ex- =FLOOR(15.67, 1) >> Output: 15
=MOD()
This function returns the reminder part of the division of nos.
Syntax : =MOD(number, divisor)
Ex- =MOD(10, 3) >> Output: 1