Arithmetic Functions in Ms-Excel

In this video we can discuss about Some Arithmetic Functions or Formulas in using our Excel Sheet.

Notes of Above Topic:-

1. SUM ():-

Adds all the numbers in arrange of cells.

Syntax:- 

=SUM (num1, num2, and nun)

2. ABS ():-

It gives the absolute value of a number. It displays the number without sign.

Syntax:-

=ABS (number)

3. EVEN ():-

If the number is divisible by 2.

Syntax:-

=EVEN (number)

4. ODD ():- 

If the number is not divisible by 2.

Syntax:-

=ODD (number)

5. PRODUCT ():-

Multiply all the numbers give as arguments and it returns the product.

Syntax:-

=PRODUCT (number1, number2,)

6. PI ():- 

It gives the value of pi. Pi=22/7=3.14

Syntax:-

=PI ()

7. FACT ():-

It gives the factorial of a given number (!)

Syntax:- 

=FACT (number)

8. POWER ():- It gives the result of a number raised to power

Syntax:-

=POWER (number, power)

9. SQRT ():-

It gives the square root of a given number 

Syntax:-

=SQRT (number)