Scribd
Upload
3 views2 pages

Essential Excel Formulas Guide

The document provides a list of various formulas used in spreadsheet applications, along with their descriptions and examples. Each formula serves a specific function, such as performing calculations, manipulating text, or checking conditions. The document includes functions like SUM, AVERAGE, IF, and VLOOKUP, among others.

Uploaded by

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

Essential Excel Formulas Guide

The document provides a list of various formulas used in spreadsheet applications, along with their descriptions and examples. Each formula serves a specific function, such as performing calculations, manipulating text, or checking conditions. The document includes functions like SUM, AVERAGE, IF, and VLOOKUP, among others.

Uploaded by

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

Formula Example Description

SUM 6 Adds numbers together


AVERAGE 20 Calculates average
MIN 1 Finds minimum value
MAX 9 Finds maximum value
ROUND 3.14 Rounds number to 2 decimals
SQRT 4 Square root
POWER 8 2 raised to 3
CONCATENHello WorlJoin text values
LEFT Open First 4 characters
RIGHT AI Last 2 characters
MID pen Extracts 3 chars from 2nd position
LEN 6 Length of text
TRIM Excel Removes extra spaces
PROPER Hello WorlCapitalizes first letters
UPPER EXCEL Converts to uppercase
LOWER excel Converts to lowercase
TODAY 45978 Returns current date
NOW 45978.53 Returns current date and time
YEAR 2025 Extracts year from date
MONTH 11 Extracts month from date
DAY 17 Extracts day from date
IF Yes Checks condition
AND 1 Logical AND
OR 1 Logical OR
NOT 0 Logical NOT
IFERROR Error Handles error
VLOOKUP #N/A Search value in first column
HLOOKUP #N/A Search value in first row
INDEX Adds numbe Get value from row & column
MATCH #N/A Find position of value
COUNT 3 Counts numbers
COUNTA 4 Counts non-empty cells
COUNTIF 0 Counts values matching criteria
COUNTIFS 0 Multiple conditions
AVERAGEIF #DIV/0! Average with condition
PMT -566.137 Loan payment calculation
FV 34003.04 Future value of investment
NPV 4815.928 Net present value
IRR Err:523 Internal rate of return
ISNUMBER 1 Checks if value is number
ISTEXT 1 Checks if value is text
ISERROR 1 Checks if error
ISBLANK 0 Checks if cell is empty

You might also like