Scribd
Upload
3 views1 page

Excel Formulas Guide

This document provides a comprehensive guide to Excel formulas, categorizing them into basic, logical, text, lookup, date & time, and conditional formulas. Each category includes examples of commonly used formulas such as SUM, IF, CONCAT, VLOOKUP, and TODAY. The guide serves as a quick reference for users to efficiently utilize Excel's formula capabilities.

Uploaded by

mohdjameelmohdjameel044
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
3 views1 page

Excel Formulas Guide

This document provides a comprehensive guide to Excel formulas, categorizing them into basic, logical, text, lookup, date & time, and conditional formulas. Each category includes examples of commonly used formulas such as SUM, IF, CONCAT, VLOOKUP, and TODAY. The guide serves as a quick reference for users to efficiently utilize Excel's formula capabilities.

Uploaded by

mohdjameelmohdjameel044
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

Excel Formulas – Complete Guide

Basic Formulas
SUM: =SUM(A1:A10)
AVERAGE: =AVERAGE(A1:A10)
COUNT: =COUNT(A1:A10)
MAX: =MAX(A1:A10)
MIN: =MIN(A1:A10)

Logical Formulas
IF: =IF(A1>=50,"Pass","Fail")
AND: =AND(A1>50,B1>50)
OR: =OR(A1>50,B1>50)

Text Formulas
CONCAT: =CONCAT(A1," ",B1)
LEFT: =LEFT(A1,4)
RIGHT: =RIGHT(A1,2)
LEN: =LEN(A1)

Lookup Formulas
VLOOKUP: =VLOOKUP(A1,A2:D10,2,FALSE)
XLOOKUP: =XLOOKUP(A1,A:A,B:B)
INDEX+MATCH: =INDEX(B:B,MATCH(A1,A:A,0))

Date & Time


TODAY: =TODAY()
NOW: =NOW()

Conditional
SUMIF: =SUMIF(A:A,"Apple",B:B)
COUNTIF: =COUNTIF(A:A,"Pass")
IFERROR: =IFERROR(A1/B1,"Error")

You might also like