**CREATE FORMULA IN EXCEL EASILY.**

Here we will learn about CREATING FORMULA or FORMULA in EXCEL. Here we will learn how to put FORMULA in a CELL in EXCEL SHEET. After applying FORMULA, we can do our work very quickly and very easily. So let’s learn how to put FORMULA in any CELL.

01. ADD (SUM) (add).

02. SUBTRACTION (subtract).

03. MULTIPLY (Multiplication).

04. DIVIDE (Part).

ADD ,SUM

It is very easy to add any CELLS or to add ADD or SUM FORMULA anywhere. And just by doing some STEPS we can complete it.

**STEP -1 #** First of all we will SELECT the CELL in which we have to put FORMULA of ADD. After that we will PRESS the = K BOTTOM.

**STEP -2 #** After that we will CLICK on the one CELL we have to add.

**STEP -3 #** After that we will PRESS the BUTTON of + and then CLICK on the second CELL which we have to add.

If we want to add more CELL, we will SELECT and CELL and PRESS the BUTTON of + and when all CELL is SELECT then PRESS the BUTTON of ENTER and we get the SUM of all that SELECT CELL or The joint is found. We can also see and understand it in the FORMULA bar mentioned in the photo.

Subtracting any CELL is as easy as adding. So let us also learn to subtract.

**STEP -1 # **First of all we will select the CELL in which the CELL we have to put FORMULA of SUBTRACTION and then we will PRESS the BUTTON of =.

**STEP -2 #** After that we will CLICK on a CELL from which we have to subtract.

**STEP -3 #** After that we will PRESS the BUTTON of (-) subtract (SUTRACT) and CLICK it on the CELL which we have to subtract.

After that ENTER PRESS will do and as soon as ENTER PRESS we get the difference between them.

Multiplying any CELL is very easy. So let’s also learn to do multiply.

**STEP -1 #** First of all we will select CELL in which CELL we have to put FORMULA of MULTIPLY and after that we will PRESS = BUTTON.

STEP -2 # After that we will click on a CELL which we have to multiply.

STEP -3 # After that we will PRESS the BUTTON of (*) multiplication (MULTIPLY) and CLICK on the CELL we have to multiply.

And similarly, multiplying all the CELLs will be done by SELECT and then ENTER PRESS and after PRESS ENTER we get multiplication of all of them. So in this way we can easily multiply any CELL.

It is very easy to do part of any CELL. So let us also learn how to participate.

**STEP -1 # **First of all we will select CELL in which CELL we have to put FORMULA of DIVIDE and after that we will PRESS = BUTTON.

STEP -2 # After that, we will CLICK on a CELL in which we have to participate.

STEP -3 # After that we will PRESS the BUTTON of the (/) part (DIVIDE) and CLICK it on the CELL from which we have to divide.

After that ENTER PRESS will do and as soon as ENTER PRESS we get the answer of part. So in this way we can easily run any CELL.

**© 2020 NtOffice.in**** **। All Rights Reserved.

ABOUT US । CONTACT US । TERMS OF USES । DISCLAIMER । PRIVACY POLICY

WhatsApp

Google+

Facebook

Telegram

- HOME
- TUTORIAL▼
- MS EXCEL▼
- INTRODUCTION
- OPEN EXCEL AND EXCEL BENEFIT
- CREATE NEW EXCEL FILE, SAVE AND CLOSE EXCEL
- COPY AND PASTE
- ADVANCE FILLING AND AUTO FILLING
- FIND AND REPLACE
- UNDO/REDO AND GOTO
- FONT STYLE
- FORMAT PAINTER
- SPEAK CELLS
- CREATE FORMULA
- FLASH FILL
- HIDE, UNHIDE ROW AND COLUMN
- FREEZE PANES
- INSERT CELL ROW AND COLUMN
- CONDITIONAL FORMATTING
- COMPARE TWO SHEETS
- DATA SORTING

- MS EXCEL
- BLOGS
- ABOUT US
- CONTACT US