Excel math and trig formulas in hindi,Excel math and trig function in hindi

Описание к видео Excel math and trig formulas in hindi,Excel math and trig function in hindi

ABS
Return the absolute value of a number,a number without its sign.
AGGREGATE
This function has multiple argument lists.Please select one of them.
PRODUCT
Multiplies all the numbers given as arguments.
SQRT
Return the square root of a number.
POWER
Return the result of a number raised to a power.
COMBIN
Return the number of combinations for a given number of items.
SIN
Return the sine of an angle.
COS
Return the cosine of an angle.
TAN
Returns the tangent of an angle.
EVEN
Rounds a positive number up and negative number down to the nearest even integer.
ODD
Rounds a positive number up and negative number down to the nearest odd integer.
FACT
Return the factorial of a number,equal to 1*2*3....*Number.
FACTDOUBLE
Returns the double factorial of a number.
INT
Round a number down to the nearest integer.
ROUND
Round a number to a specified number of digits.
ROUNDUP
Rounds a number up,away from zero.
ROUNDDOWN
Rounds a number down, toward zero.
CEILING
Rounds a number up,to the nearest multiple of significance.
FLOOR
Rounds a number down to the nearest multiple of significance.
LCM
Return the least common multiple.
GCD
Return the greatest common divisor.
PI
Returns the value of Pi,3.14.1
LOG
Returns the logarithm of a number to the base you specify.
MOD
Return the remainder after a number is divided by a divisor.
QUOTIENT
Return the integer portion of a division
SUM
Adds all the numbers in a range of cells
SUMIF
Adds the cells specified by a given condition or criteria.
SUMIFS
Adds the cells specified by a given set of conditions or criteria.
SUMPRODUCT
Return the sum of the products of corresponding ranges or arrays.
SUMX2PY2
Return the sum total of sums of squares of numbers in two corresponding ranges or arrays.
SUMX2MY2
Sums the differences between the squares of two corresponding ranges or arrays.
MDETERM
Return the matrix determinant of an array.
MINVERSE
Return the inverse matrix for the matrix stored in an array.
MMULT
Returns the matrix product of two arrays,an array with the same number of rows as array1 and columns as array2.
https://instagram.com/computerlearnin...

Комментарии

Информация по комментариям в разработке