Software Engineering Course | Duration: 1 Year | Fees: 1500/- Monthly | Learn 25+ Language | Call / WhatsApp: +91 9650597419 (Vinay Sir) | Address: Sec - 36, Narsinghpur, Gurugram, Haryana
All Computer Notes | Practice Assignment | Hindi & English Medium Computer PDF Notes | Computer eBooks | Call / WhatsApp: +91 9650597419 (Vinay Sir) Grow Your Coaching Business 10x with your own coaching app | अपने नाम से Teaching App बनवायें | Call / WhatsApp: +91 9650597419 (Vinay Sir)

Introduction

MS Excel, short for Micro Soft Excel, is a widely used powerful spreadsheet program that provides access to different worksheets in a single workbook. Users can store large amount of data in these worksheets using existing cells. One of the significant advantages of using excel is that it allows us to perform various calculations, operations and analyses. Excel has a widely wide range of pre defined functions and we can perform almost every operation in excel by creating formulas through existing functions.

In this tutorial, we will discuss the various step by step methods of creating formulas in excel properly. The steps for creating or using a formula differ for each excel function as each function requires different arguments. However, the basic concept remains the same. Before we discuses the methods of creating a formula, let us briefly understand the definition of an excel formula.

What is the Formula in Excel?
An Excel Formula is nothing but an introductory statement consisting of one or more 'operands' and 'operators'. The Formulas in excel help us specify the relationship between the value recorded within the cells in the worksheet, perform mathematical calculations on the recorded values and retrieve the desired results in a resultant cell.

One essential point to note while using the formulas in excel is that we must always start them with an equal sign (=). If we don't start the formulas with an equal sign, they are not treated as formulas but only as a text string.

The Difference Between a Formula and Function

An excel formula is a statement or an equation structured manually by a user to perform any calculation.
At the same time, The excel function is the pre defined calculation in the spreadsheet program. We can use more than one function in a formula.

Example of Formula: =A1+A2+A3+A4
Example of Function: =SUM(A1:A3)

How to Create a Formula in Excel?
There are several methods we can use to create formulas in excel. We discuss the most common methods below, and each method has its advantages. All of the following methods for creating formulas work in all versions of excel.

Creating formulas using Constants and Operators
When creating formulas in excel, constants are numbers, dates or text values involved within the formula. In addition, the operators are any sign, symbol, or character that refers to an action or operation to be performed. The most common arithmetic operations include addition, subtraction, multiplication, division, exponentiation and modulus operations.

To create a basic excel formula in an excel cell using the constants and operators, we must perform the steps below.

First, we need to select a cell to record the output or result.
Next, we must type an equal symbol (=) and enter the formula equation to perform the calculation.
Lastly, we must press the enter key on the keyboard to obtain the results.

Creating an excel formula using constants and operators is different from writing an equation in maths. The fundamental difference is that we start the formula with an equal sign in excel, while in mathematics. We usually insert an equal sign at the end.

For example, if we want to add two numbers (3 and 5) an excel formula will look like =3+5. However, in maths, we use 3+5 = . When we insert an excel formula in an excel cell and press the enter key. The result of the formula appears like the following image.
Instead of typing the numbers directly into the Formula equation, we can also refer to the corresponding cells that contain the required numbers or values in the sheet. It is more convenient and easier to use cell reference in formulas when working with large data sets.
Furthermore, one advantage of using a cell reference is that the formula results are automatically updated in real time when ever we change the value in the corresponding cell / range.

To create a formula using the cell references, we can perform the below steps:
First, we need to select a cell to record the output
Next, we enter the equal sign (=). After that, we need to type the first cell that contains the number. It is not mandatory to always type the cell reference. Instead, we can also click on the specific cell, and excel will automatically fetch the cell reference of that cell in the applied formula. This eliminates human error.

In the next step, we must type the operator sign we want to apply for the formula.
For example: If we want to sum up the first and second cell values, we must use the addition sign (+) between them.

After entering the operator sign, we need to type the cell reference of another number that we want to include in our formula.

Lastly, we must press the enter key to obtain the formula result.

Suppose, our example sheet contains two numbers 3 and 5, in the cells A1 and B1. we need to calculate the sum of these values in cell C1 using the formula containing cell references. So, we have to apply the following formula in a Cell C1:

=A1 + B1

After we press the Enter key, The result will appear in a Cell C1, as shown below

If the values are recorded in more than two cells, we can use the cell reference of each cell similarly. For example: If we have values in cells A1, B1 and C1, we can add their corresponding values using the formula =A1+B1+C1. However, if several cells are required in a formula. It is better to try using existing functions and ranges of cells.

### All Computer Notes

Basic Computer Notes
1.Basic Computer Notes in English
2.Basic Computer Notes in Hindi
3.Computer Related Full Form
4.Computer Shortcut Keys
5.Keyboard Symbols Name
MS Word Notes in Hindi
1.MS Word Practical Notes
2.Chapter1: Introduction to MS Word
3.Chapter 2: Some Basic Point of MS Word
4.Chapter3 : MS Word - File Menu
5.Chapter 4: MS Word - Home Menu
6.Chapter 5: MS Word - Insert Menu
6.Chapter 5: MS Word - Insert Menu
7.Chapter 6: MS Word - Page Layout Menu
8.Chapter 7: MS Word - References Menu
9.Chapter 8: MS Word - Mailing Menu
10.Chapter 9: MS Word - Review Menu
11.Chapter 10: MS Word - View Menu
MS Word Notes in English
3.Chapter3: MS Word Page Layout Menu
MS Excel Notes in Hindi
1.Chapter1: Introduction to MS Excel
4.Chapter4: MS Excel Page Layout Menu
MS Excel Notes in English
1.Chapter1: Introduction to MS Excel
4.Chapter4: MS Excel Page Layout Menu
MS PowerPoint Notes in English
1.Chapter1: Introduction to MS MS PowerPoint
MS PowerPoint Notes in Hindi
1.Chapter1: Introduction to MS PowerPoint
MS Excel Formula Notes
2.How to Subtract in Excel
3.How to Multiply in Excel
4.How to Divide in Excel
5.MAX Formula in Excel
6.MIN Formula in Excel
7.ROMAN Formula in Excel
8.SQRT Formula in Excel
9.POWER Formula in Excel
10.LCM Formula in Excel
11.GCD Formula in Excel
12.FACT Formula in Excel
13.LOWER Formula in Excel
14.UPPER Formula in Excel
15.PROPER Formula in Excel
16.LEFT Formula in Excel
17.RIGHT Formula in Excel
HTML Notes
Chapter 1 : Introduction to HTML
Chapter 2 : HTML Versions
Chapter 3 : HTML DOCTYPE Declaration
Chapter 4 : HTML Attributes
Chapter 5 : HTML Heading Tag
Chapter 6 : HTML Text Formatting Tag
Chapter 7 : HTML Anchor Tag
Chapter 8 : HTML Image Tag
Chapter 9 : HTML List Tag
Chapter 10 : HTML Table Tag
Chapter 11 : HTML Marquee Tag
Chapter 12 : HTML Preformatted & Horizontal Tag
Chapter 13 : HTML Image Tag
Chapter 14 : HTML Anchor Tag
Chapter 15 : HTML Audio Tag
Chapter 16 : HTML Video Tag
Chapter 17 : HTML Iframe Tag
Chapter 18 : HTML Form Tag
Chapter 19 : HTML Website Layout