Scribd
Upload
5 views3 pages

Advanced MS Excel Formulas

The document provides a list of advanced MS Excel formulas along with their uses and examples. Key formulas include SUM, AVERAGE, IF, VLOOKUP, and others that facilitate calculations, data analysis, and text manipulation. Each formula is accompanied by a brief explanation and a practical example for better understanding.

Uploaded by

kkumar08411
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
5 views3 pages

Advanced MS Excel Formulas

The document provides a list of advanced MS Excel formulas along with their uses and examples. Key formulas include SUM, AVERAGE, IF, VLOOKUP, and others that facilitate calculations, data analysis, and text manipulation. Each formula is accompanied by a brief explanation and a practical example for better understanding.

Uploaded by

kkumar08411
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

Advanced MS Excel Formulas with Explanation &

Examples

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

AVERAGE
Use: Calculates average
Example: =AVERAGE(A1:A5)

IF
Use: Checks condition
Example: =IF(A1>50,"Pass","Fail")

SUMIF
Use: Conditional sum
Example: =SUMIF(A1:A5,">50")

VLOOKUP
Use: Search vertically
Example: =VLOOKUP(A2,A1:B10,2,FALSE)

INDEX+MATCH
Use: Advanced lookup
Example: =INDEX(B1:B10,MATCH(A2,A1:A10,0))

LEFT
Use: Extract left text
Example: =LEFT(A1,4)

RIGHT
Use: Extract right text
Example: =RIGHT(A1,4)

MID
Use: Extract middle text
Example: =MID(A1,2,3)
LEN
Use: Text length
Example: =LEN(A1)

ROUND
Use: Round value
Example: =ROUND(A1,2)

RAND
Use: Random number
Example: =RAND()

RANDBETWEEN
Use: Random range
Example: =RANDBETWEEN(1,100)

TODAY
Use: Current date
Example: =TODAY()

NOW
Use: Current date & time
Example: =NOW()

PMT
Use: Loan EMI
Example: =PMT(10%/12,12*5,-100000)

COUNT
Use: Count numbers
Example: =COUNT(A1:A10)

COUNTA
Use: Count non-empty
Example: =COUNTA(A1:A10)

COUNTBLANK
Use: Count blanks
Example: =COUNTBLANK(A1:A10)

AND
Use: Multiple conditions true
Example: =AND(A1>10,B1<20)

OR
Use: Any condition true
Example: =OR(A1>10,B1<20)

You might also like