# 5 Most Used Excel Formula

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.

# 5 Most Used Excel Formula

## 5 Most Used Formulas of Excel are

### 1. Vlookup Formula in Excel 2. If Formula in Excel 3. Pivot Table in Excel 4. Or Formula in Excel 5. And Formula in Excel

#### 1. Vlookup Formula in Excel

Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number.
=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).

#### 2. If Formula in Excel

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says:
IF(Something is True, then do something, otherwise do something else)
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

#### 3. PivotTable in Excel

Being able to analyse all the data in your worksheet can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. Excel can help you by recommending and then automatically creating PivotTables, which are a great way to summarize, analyse, explore, and present your data.

#### 4. And Formula in Excel

Use the AND function to determine if all conditions in a test are TRUE.

#### 5. Or Formula in Excel

Use the OR function to determine if any conditions in a test are TRUE. Use the OR function to test multiple conditions at the same time, up to 255 conditions total.
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788

# Our Other Services

### Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!

### Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788

### Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!