Mathematical Functions –
Sum (Range of Cells): It is used to add the cell values or range of cells.
Syntax- =sum(Number1, Number2, …) : Number1, Number2, …are arguments whose total are to be calculated.
Ex- =sum(A1:D6)
-----------------------------------------------------
Round: It is used for round the number to a specified number for digits.
Syntax- =round(number, count) : The number to be rounded.
Ex- =ROUND(2634.26,-3)
Output : 3000
-----------------------------------------------------
Roundup: It rounds a number up, away from 0.
Syntax- =roundup(number, count) : The number to be rounded up.
Ex- =Roundup (2345.5678, 2)
Output : 2345.57
-----------------------------------------------------
Rounddown: It rounds a number down, toward 0.
Syntax- =rounddown(number, count) : The number to be rounded down.
Ex- =Rounddown (2345.5678, 2)
Output : 2345.56
-----------------------------------------------------
Sumif: It is used to sum the value according to the condition. This function require three field as given below:
Syntax:- =sumif(range, criteria, sum-range) The range to be evaluated by the given criteria)
- range (cell range from which criteria would search)
- Criteria (value that you want to sum)
- Sum range (cell range from where similar value would be sum)
-----------------------------------------------------
Product: This multiplies of given numbers.
Syntax:- =product(Number1, Number2, …) : Number1, Number2, …are arguments to be multiplied and a result returned.
Ex- =Product(A2:C2)
-----------------------------------------------------
Power: It returns the result of a number raised to a given Power.
Syntax:- =product(base, exponent) : The base a of the power a^b
Ex- =Power(6, 2)
Output: 36
-----------------------------------------------------
Mod: This function returns the reminder of a division.
Syntax:- =mod(Dividend, Divisor) : The number to be divided.
Ex- =Mod(24, 5)
Output: 4
-----------------------------------------------------
Trunc: It truncates a number to an integer by removing the decimal or fractional, Part of the number.
Syntax:- Trunc(Number, Count) : The number to be truncated.
Ex- =TRUNC (5623.5657, 2).
Output: 5623.56
-----------------------------------------------------
Ceiling: The Ceiling Function in Calc returns a given number rounded up to a specified multiple. Ceiling Function is always used for rounding up. Its purpose is to Round a number up to nearest multiple. It returns a rounded number.
Syntax:- =CEILING(Number, Significance) : The number to be rounded up.
Ex- =CEILING(25, 4)
Output: 28
-----------------------------------------------------
Floor: The Floor function in Calc is very similar to the round down function as it rounds down the number to its significance for example if we have numbered as 25 and the significance is 4 the output would be 24, this function takes two arguments as an input one is a number while other is the significance value.
Syntax:- =FLOOR(Number, Significance) : The number to be rounded down.
Ex- =FLOOR(25, 4)
Output: 24
-----------------------------------------------------
SQRT() : Return the Square root of given number.
Syntax: =SQRT(Number) : A positive value for which the square root is to be calculated.
Note- If number is negative, SQRT returns the Err:502 error value.
Example: =SQRT(5)
Output: 2.23606797749979
-----------------------------------------------------
FACT() : Return the factorial of a number
Syntax : =FACT(Number) : The number for which the factorial is be calculated.
Note- If number is negative, SQRT returns the Err:502 error value and if number is not an integer, it is truncated.
Example:
=FACT(5) ---> Output: 120
=FACT(5.42) ---> Output: 120
=FACT(-5) ---> Output: Err:502
-----------------------------------------------------
INT() : Rounds a number down to the nearest integer.
Syntax : =INT(Number) : The number to be rounded down.
Example:
=INT(6.34) ---> Output: 6
-----------------------------------------------------
EVEN() : Returns number rounded up to the nearest even integer. If Number is an even integer, no rounding occurs.
Syntax : =EVEN(Number) : The number to be rounded up.
Example:
=EVEN(5.5) ---> Output: 6
=EVEN(5) ---> Output: 6
=EVEN(-15) ---> Output: -16
-----------------------------------------------------
ABS() : Returns the absolute value of a number. The absolute value of a number is a number without its sign.
Syntax: =ABS(number) : The number whose absolute value is to be returned.
Example:
=ABS(-45) --> Output: 45
-----------------------------------------------------
0 Comments