Scribd
Upload
2 views1 page

Essential Excel Formulas Guide

The document provides a list of common Excel formulas along with their functions and examples. Key formulas include SUM for adding numbers, AVERAGE for calculating averages, and VLOOKUP for searching data. Other formulas mentioned include MAX, MIN, COUNT, IF, CONCAT, and ROUND.

Uploaded by

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

Essential Excel Formulas Guide

The document provides a list of common Excel formulas along with their functions and examples. Key formulas include SUM for adding numbers, AVERAGE for calculating averages, and VLOOKUP for searching data. Other formulas mentioned include MAX, MIN, COUNT, IF, CONCAT, and ROUND.

Uploaded by

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

SUM Formula

Adds numbers. Example: =SUM(A1:A5)


AVERAGE Formula
Finds average. Example: =AVERAGE(A1:A5)
MAX Formula
Finds maximum value. Example: =MAX(A1:A5)
MIN Formula
Finds minimum value. Example: =MIN(A1:A5)
COUNT Formula
Counts numeric cells. Example: =COUNT(A1:A5)
IF Formula
Logical condition. Example: =IF(A1>50,"Pass","Fail")
VLOOKUP Formula
Searches data. Example: =VLOOKUP(A1,A2:B10,2,FALSE)
CONCAT Formula
Joins text. Example: =CONCAT(A1,B1)
ROUND Formula
Rounds number. Example: =ROUND(A1,2)

You might also like