##
**Write Formula in Excel Worksheet**

You may have heard about the feature of Excel that you can write a formula in its cell to perform the mathematical or logical function of values you enter. If you write the formula properly, it will calculate automatically and results for every change of its input values.

Excel formula is very useful for monthly official data calculation and as well as personal data calculation.

Here, we will discuss How to Write Formula in Excel Worksheet to perform Mathematical function only?

**A2=10,**

**B2=20,**

**C2= To be calculated**.

### Addition Formula in Excel :

**C2**against heading Answer

**for the values entered in cell A2 and cell B2, the general mathematical formula will**

**10+20=30**and if we write the same in the form of the cell then it will be

**C2=A2+B2**.

####
**Method 1 :**

**cell**

**C2**by left-clicking of the mouse or keyboard at cell C2.

Press

**Enter.**

####
**Method 2 :**

Select** **cell **C2** by left-clicking of the mouse or keyboard at cell C2.

**A2**by using the mouse or the keyboard.

**B2**by using the mouse or the keyboard.

### Subtraction Formula in Excel :

Now, to create a subtraction formula in cell

**C2**against heading Answer

**for the values entered in cell A2 and cell B2**

**,**the general mathematical formula will

**20-10=10**and if we write the same in the form of the cell then it will be

**C2=B2-**

**A2**.

####
**Method 1 :**

Select** **cell **C2** by left-clicking of the mouse or keyboard at cell C2.

Press

**Enter.**

####
**Method 2 :**

Select** **cell **C2** by left-clicking of the mouse or keyboard at cell C2.

**B2**by using the mouse or the keyboard.

**A2**by using the mouse or the keyboard.

### Multiplication Formula in Excel :

Now, to create a multiplication formula in cell

**C2**against heading Answer

**for the values entered in cell A2 and cell B2**

**,**the general mathematical formula will

**10 x 20=200**and if we write the same in the form of the cell then it will be

**C2=A2*B2.**

####
**Method 1 :**

**cell**

**C2**by left-clicking of the mouse or keyboard at cell C2.

**Enter.**

####
**Method 2 :**

Select** **cell **C2** by left-clicking of the mouse or keyboard at cell C2.

**B2**by using the mouse or the keyboard.

As soon as you press Enter it will show the result as 200 in cell C2.

### Division Formula in Excel :

Now, to create a division formula in cell

**C2**against heading Answer

**for the values entered in cell A2 and cell B2**

**,**the general mathematical formula will

**10**

**➗**

**20=0.5**and if we write the same in the form of the cell then it will be

**C2=A2/B2.**

####
**Method 1 :**

**cell**

**C2**by left-clicking of the mouse or keyboard at cell C2.

**Enter.**

####
**Method 2 :**

Select** **cell **C2** by left-clicking of the mouse or keyboard at cell C2.

**B2**by using the mouse or the keyboard.

**How to Write Formula in Excel Worksheet?**