How to Create Excel Formula in MS Excel Worksheet?

As on our screen there are different sales and expenses of different months, and now we want to calculate the profit, so for that we will just write the formula for it by using cell's location.

For example, cell b2=180, and cell b3=160, than we write tye formula as '=b2-b3' on our desirable cell where we want the answer of it.

Now suppose if you want to total the sales row, so for that we will use the pre inserted functions in MS Excel. There are total of 450 functions available in Microsoft Excel.

So to get the total of all the sales rows, we will write '=sum(' and then select all the column and then after click on any different cell. We will notice that the total of all will be shown in the cell where we entered the formula.

Similarly we can use average formula to count average of all the cells which we want.

In this course you will learn how to build Basic and Advance Formulas for MS EXCEL with Easy to Understand Videos in Hindi.

FAQs

A formula is a mathematical expression that you enter into a cell of your worksheet. A formula can also be used to calculate values such as profit margin or cost. The INDIRECT function returns the value of A1 for use in formulas. You can easily create an Excel formula using this function and it will return the value of A1. Excel has different formula types that are used for different types of calculations. Using formulas in Excel is an intuitive process that can be learned through practice. A formula can also be created using cells, however, it is simpler to understand the formulas by creating them in a text file and importing it into Excel. Formula strings can be copied and pasted directly into Excel cells.

When you need to set up a lookup formula, you will need to use Excel’s conditional formatting feature. You can also use the Excel chart function to create a chart of data. Step 1: Add the cells that you want to format with the lookup formula Step 2: Select Conditional Formatting from the Home tab on the ribbon, then click More Rules Step 3: On the Format Cells rules tab, select the Use A Formula To Determine What To Show option Step 4: Enter your formula in cell A1 and press enter on your keyboard. Press F5 on your keyboard to refresh the spreadsheet if it is not already open. Many people are not familiar with the concept of lookup formulas. They are created when you want to calculate a value based on another value in a table. If you are looking for an example of a lookup formula, consider this equation: =VLOOKUP(D2,T2:T100,1) The first argument is the column number and the second argument is the row number. This formula returns all values from row 2 to 100 in column D2. If you want to find values from rows 1 to 4, use =VLOOKUP(D1, T1:T4,5).

The Sum formula is a mathematical equation that is used to calculate the total of a list of numbers. It is also called the sum function or the summing up.A sum formula is one that adds or subtracts a value to the cells inside it. Sum formulas are mainly used when the user wants to add or subtract data in a certain range of cells. There are different types of sum formulas - simple, compound, and custom formulas. A simple sum formula is just an equation with one variable in it. For example, the formula =SUM(A1:A5) will add up all values in cells A1 through A5 and display the total at cell B1. Compound sum formulas are two or more independent equations. The simplest compound sum formula is =SUM(A1:B3)*C4, which calculates (=2*4)+(4*6), then displays the total at cell B4 by multiplying.

Course Content

What is MS Excel

Menu in Excel

How to Use Forums to Ask Questions

Quick Access Toolbar

Formula Bar in Excel

Status Bar in MS Excel

Navigation in MS Excel

Shortcuts in MS Excel

Format Painter in MS Excel

Data Entry

Data Entry in MS Excel

Autofill in MS Excel

Data Entry for Date-Time in MS Excel

Undo-Redo in MS Excel

Comments in MS Excel

Saving File in MS Excel

Creating Formulas

Creating Formula in MS Excel

Copy Formula in Excel

Till Date Formula in MS Excel

Pct Calculation in MS Excel

Absolute in MS Excel

Sum Average in MS Excel

Other Common Functions In MS Excel

Formating

Formatting Fonts in MS Excel

Adjusting Rows & Columns in MS Excel

Alignment in MS Excel

Formatting Borders in MS Excel

Formatting Numbers in MS Excel

Formatting Date-Time in MS Excel

Conditional Formating in MS Excel

Formatting Tables in MS Excel

Formatting Shapes in MS Excel

Adjusting Layout

Resizing Row & Column in MS Excel

Hide-Unhide Row and Column in MS Excel

Copy, Move, Insert Data in MS Excel

Find Replace in MS Excel

Print

Printing in MS Excel

Page Break Preview in MS Excel

Page Setup in MS Excel

Charts

Creating Charts in MS Excel

Types of Chart in MS Excel

Formatting Charts in MS Excel

Chart Elements in MS Excel

Sparklines in MS Excel

Adjusting Workbook

Freezing Workbook in MS Excel

Splitting Sheets in MS Excel

Outline in MS Excel

Multiple work books

Manage Multiple Workbook in MS Excel

Working with Sheets in MS Excel

Copy & Delete Sheets in MS Excel

Use of Formula in Worksheet

Edit Links in MS Excel

If condition VLOOKUP

If Condition in MS Excel

VLOOKUP in MS Excel

VLOOKUP Exact in MS Excel

COUNTIF in MS Excel

Protecting sheets

Protecting Sheets in MS Excel

Securing Workbook in MS Excel

Password to Workbook in MS Excel

Sharing Workbook in MS Excel

Track Changes in MS Excel

Data Management

Sorting in MS Excel

Subtotals in MS Excel

Filter in MS Excel

Split Data in MS Excel

Flash Fill in MS Excel

Remove Duplicate in MS Excel

Data Validation in MS Excel

Pivot Table