Arithmetic Functions in Ms-Excel 2013

Arithmetic Functions in Excel 2013

ABS() -  This functions returns an absolute value of the given in the function as an argument. This function display number without any ‘+’ or ‘–’ value.

Syntax-      =abs(Number)

Example-   =abs(-5)

Ans-      5

Sqrt() à This function returns a number after calculate the square root of the given value.

        Syntax-     =sqrt(Number)

        Example-       =sqrt(16)        Ans-    4

        For Negative value-     =sqrt(abs(-16))        Ans-   4 

Power() à This function returns a value after calculating the second number is the power of first number.

      Syntax-     =power(Number, power)

      Example-       =power(10, 2)        Ans-    100

Sum()- this function returns a number after the sum of given number or cell reference as arguments.

     Syntax-     =sum(Number1, Number2, Number3, ..., ..)

      Example-       =sum(10, 12)        Ans-    22

                                =sum(c2,d2,e4,f5)

                                =sum(a1:c5)

            =sum(a1:b5,d2:e6)

                                =sum(a1:b5,10)

            =sum(a1:b5,-5)

Sumsq() – This function returns the sum of the squares of the argument as numbers.

      Syntax-     =sumsq(Number1, Number2, Number3, ..., ..)

      Example-       =sumsq(10, 12)        Ans-    244

                                =sumsq(c2,d2,e4,f5)

            =sumsq(a1:c5)

           =sumsq(a1:b5,d2:e6)

                              =sumsq(a1:b5,10)

Sumproduct() – This function returns the sum of product of corresponding range.

        Syntax-     =sumproduct(range1, range2,... ... )

        Example- Tags abs function in excel 2013arabic function in excelbase function in excelbhagwanbabucommon and easy way to use of arithmetic function with syntax and example in excel 2013degrees function in excelfact function in excelformula in excelformula in excel 2013function in excelfunction in excel 2013function in ms excelhow to use arithmetic function in excel 2013int function in excellcm function in excellog function in excelmod function in excelms excel 2013ms office 2013pi function in excelpower function in excelproduct function in excelquotient function in excelradians function in excelroman function in excelround function in excelrounddown function in excelroundup function in excelsqrt function in excelsum function in excelsumproduct function in excelsumsq function in exceltrunc function in excel