Arithmetic Functions in Ms-Excel 2013

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,... ... )

        Examplesumproduct function in excel 2013

Product()- This function returns a number after the multiplication of given number or cell-reference as arguments.

    Syntax-     =product(Number1, Number2,... ... )

    Example-     =product(5,10,18) à Ans. 9000

                            =product(c2,d2,e4,f5)

                            =product(a1:c5)

       =product(a1:b5,d2:e6)

       =product(a1:b5,10)

                            =product(a1:b5,-5)

Mod()- This function returns the remainder value after the division of number.
        Syntax-      =Mod(Number, Divisor)

        Example-        =mod(11,5) à Ans. 1

Quotient() – This function returns the quotient value after the division of given number as argument.

        Syntax-    =quotient(Number, Divisor)
        Example -     =quotient(11,5) à Ans. 2

Round()- This function returns a rounding value according to given argument.

    Syntax-    =Round(Number, Num_digits)

            Number à is the number we want to round.

            Num_digits à which we want you round off a number.

Ø  If we give num_digits is greater than 0 then number is rounded to normally.

Ø  If we give num_digits is 0 then number is rounded to nearest integer.

Ø  If we give num_digits is less than 0 then number is rounded to left of the decimal point.

a.    =round(5.1678, 2)      Ans. 5.17

b.    =round(5.1678, 0)      Ans. 5.

    Example-   =round(5.1678, -1)     Ans. 10
                            =round(5.1678, 0)      Ans. 5

Roundup()- This function returns a rounding value according to given argument.

    Syntax-      =Roundup(Number, Num_digits)

        Number à is the number we want to round.

            Num_digits à which we want you round off a number.

Ø  If we give num_digits is greater than 0 then number is rounded to normally.

Ø  If we give num_digits is 0 then number is rounded up to nearest integer.

Ø  If we give num_digits is less than 0 then number is rounded up to left of the decimal point

    Example-   =roundup(5.1678, -1)     Ans. 10
                            =roundup(5.1678, 0)      Ans. 5

Rounddown()- This function returns a rounding value according to given argument.

    Syntax-      =Rounddown(Number, Num_digits)

        Number à is the number we want to round.

            Num_digits à which we want you round off a number.

Ø  If we give num_digits is greater than 0 then number is rounded to normally.

Ø  If we give num_digits is 0 then number is rounded down to nearest integer.

Ø  If we give num_digits is less than 0 then number is rounded down to left of the decimal point

    Example-   =rounddown(5.1678, -1)     Ans. 0
                            =rounddown(5.1678, 0)      Ans. 5

Trunc()- this function returns a truncating value according to given condition.
        Syntax-      =Trunc(Number, Num_digits)

                Number à is the number we want to round.

                Num_digits à which we want you round a number. By default it is 0.

Ø  If we give num_digits is greater than 0 then number is rounded to normally.

Ø  If we give num_digits is 0 then number is rounded down to nearest integer.

Ø  If we give num_digits is less than 0 then number is rounded down to left of the decimal point.

a.    =trunc(5.1678, 2)       Ans. 5.16

b.    =trunc(5.1678, 0)       Ans. 5.

c.     =trunc(5.1678, -1)      Ans. 0

Fact() – This function returns a factorial value of the given argument.

    Syntax-     Fact(Number)

    Example-   =Fact(5)          Ans. 120

Roman() – This function converts decimal number to Roman.
    Syntax-    =Roman(Number)
    Example-  =roman(10)   Ans. X

Arabic() – This function converts roman number to Arabic number. Given argument of Roman must be as a text format.
    Syntax-     =Arabic(Text)

    Example-   =Arabic(“X”)   Ans. 10

Int() – This function rounds a number down to nearest integer.

        Syntax-     =Int(Real_Num)

        Example-     =int(9.7)  Ans. 9

Base() – This function converts a number into other number format according to give its base value and length.

    base-      2  for Binary,        8  for Octal,        10   for Decimal,     16   for Hexadecimal

        Syntax-       =Base(Num, base, [Min_Len])

        Example-     =base(12,2,4)      Ans. 1100 (convert in binary of 12 in 4 digits)


Degrees() – This function is used to converts Radians into degrees.

        Syntax-        =Degrees(Angle)

        Example-       =degrees(90)   Ans. 5156.62016

Radians() – This function is used to converts Degrees into radians.

        Syntax-      =Radians(Angle)

        Example-        =radians(90)  Ans. 1.57079633

LCM() – This function returns the Least Common Multiples of the given numbers as arguments.
        Syntax-      =Lcm(Num1, Num2,…)

        Example-    ==lcm(2,4,8)  Ans. 8


Log()- this function returns a logarithmic value of the given argument.
    Syntax-       =Log(Num1, [base])

    Example-        =log(100,10)   Ans. 2 


Pi()- This function returns the value of pi.

        Syntax-          =pi()

        Example-        =pi()   Ans. 3.141592654


0 comment(s)

Leave a Comment