Formula in Microsoft Excel

What is a Formula?

A Formula in Microsoft Excel is an expression used to perform a calculation on data and produce a result. Formulas allow us to perform calculations automatically instead of calculating values manually.

Excel formulas can use numbers, cell references, mathematical operators, and functions to perform different types of calculations.

For example:

=A1+B1

This formula tells Excel to add the values stored in cells A1 and B1.

Understanding the Formula

Consider:

=A1+B1

Excel reads the formula, performs the calculation, and displays the result in the cell.

Why are Formulas Used?

Formulas are useful because they make calculations faster, easier, and more flexible.

For example, suppose a student has marks in different subjects. Instead of manually adding the marks every time, we can use a formula:

=B2+C2+D2

If any marks are changed later, Excel can recalculate the result based on the formula.

Example

The formula in the Total column performs the calculation using the values in the respective cells.

Basic Rules of an Excel Formula

1. Formula Starts with =

A formula normally begins with an equal sign.

=A1+B1

2. Cell References Can Be Used

Instead of typing values directly, we can refer to cells.

=A2*B2

3. Mathematical Operators Can Be Used

Excel formulas can use operators such as:

Formula and Cell Reference

A major advantage of Excel formulas is that they can work with cell references.

For example:

=B2+C2

Here, Excel does not simply store the final answer. It stores the formula and uses the values from B2 and C2 to calculate the result.

This becomes especially useful when working with large amounts of data.

Formula vs Function

Formula and Function are related, but they are not exactly the same.

For example:

=A1+B1

is a formula using the addition operator.

While:

=SUM(A1:B1)

uses the SUM function.

Simple Formula Flow

Data in Cells
     ↓
Cell References
     ↓
Operator / Function
     ↓
Formula
     ↓
Excel Performs Calculation
     ↓
Result

Example

A1 = 50
B1 = 30

Formula:
=A1+B1

Result:
80

Easy Way to Remember

Formula = Excel ko calculation karne ka instruction.

One-Line Definition

A formula is an expression entered in Excel to perform a calculation and obtain a result using values, cell references, operators, and functions.

The provided Advanced Excel material introduces formulas in the context of entering data into cells and performing calculations, followed by the use of functions and their arguments.