Scribd
Upload
4 views2 pages

Essential Excel Formulas Explained

This document provides a guide on various Excel formulas including SUM, HLOOKUP, VLOOKUP, COUNT, AVERAGE, and IF. Each formula includes its use, syntax, and an example formula. The guide is designed to help users understand how to perform basic calculations and data lookups in Excel.

Uploaded by

Sachi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

Essential Excel Formulas Explained

This document provides a guide on various Excel formulas including SUM, HLOOKUP, VLOOKUP, COUNT, AVERAGE, and IF. Each formula includes its use, syntax, and an example formula. The guide is designed to help users understand how to perform basic calculations and data lookups in Excel.

Uploaded by

Sachi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Excel Formulas Guide

SUM
1. Use : To perform addition of two or more values

2. Syntax : =SUM(value1,value2,...)

3. Formula : =SUM(E:E)

4. Example:

HLOOKUP
1. Use : Searches for a value in the top row of a table or array and returns a value in the
same column from a row you specify.

2. Syntax : =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

3. Formula : =HLOOKUP(105,A1:C5,2,FALSE)

4. Example:

Insert Screenshot Here


VLOOKUP
1. Use : Looks for a value in the first column of a range and returns a value in the same row
from another column.

2. Syntax : =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

3. Formula : =VLOOKUP(105,A1:C5,3,FALSE)

4. Example:

Insert Screenshot Here

COUNT
1. Use : Counts the number of numeric values in a range.

2. Syntax : =COUNT(value1,value2,...)

3. Formula : =COUNT(A1:A10)

4. Example:

Insert Screenshot Here

AVERAGE
1. Use : Returns the average (arithmetic mean) of the arguments.

2. Syntax : =AVERAGE(number1,number2,...)

3. Formula : =AVERAGE(A1:A10)

4. Example:

Insert Screenshot Here

IF
1. Use : Checks whether a condition is met, returns one value if TRUE, another if FALSE.

2. Syntax : =IF(logical_test,value_if_true,value_if_false)

3. Formula : =IF(A1>10,"Pass","Fail")

4. Example:

Insert Screenshot Here

You might also like