CREATE FORMULA

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

1 - ADD ,SUM

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.

CREATE FORMULA

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.

2 - SUBTRACTION

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.

CREATE FORMULA

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

3- MULTIPLY

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.

CREATE FORMULA

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.

CREATE FORMULA
4- DIVIDE

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.

CREATE FORMULA

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.

CREATE FORMULA

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.

CREATE FORMULA

For more information see VIDEO -

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

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

WhatsApp
Google+
Facebook
Telegram