Scribd
Upload
9 views1 page

Essential Excel Formulas Guide

This document provides a comprehensive guide to common Excel formulas categorized into Basic Math, Text Functions, Logical Functions, Lookup & Reference, Date & Time, Financial, and Advanced functions. Each category includes specific formulas with brief descriptions of their functionality. The guide serves as a quick reference for users to perform various calculations and data manipulations in Excel.

Uploaded by

dosap11773
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
9 views1 page

Essential Excel Formulas Guide

This document provides a comprehensive guide to common Excel formulas categorized into Basic Math, Text Functions, Logical Functions, Lookup & Reference, Date & Time, Financial, and Advanced functions. Each category includes specific formulas with brief descriptions of their functionality. The guide serves as a quick reference for users to perform various calculations and data manipulations in Excel.

Uploaded by

dosap11773
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

Common Excel Formulas Guide Basic Math =SUM(range) – Adds numbers

=AVERAGE(range) – Calculates average


=MIN(range) – Smallest number
=MAX(range) – Largest number
=COUNT(range) – Counts numeric cells
=COUNTA(range) – Counts non-empty cells
Text Functions =LEFT(text, num) – Returns left characters
=RIGHT(text, num) – Returns right characters
=MID(text, start, num) – Extracts text
=LEN(text) – Counts characters
=CONCAT(text1, text2) – Joins text
=UPPER(text) – Uppercase
=LOWER(text) – Lowercase
Logical Functions =IF(condition, value_if_true, value_if_false)
=AND(condition1, condition2)
=OR(condition1, condition2)
=NOT(condition)
Lookup & Reference =VLOOKUP(value, table, col, FALSE)
=HLOOKUP(value, table, row, FALSE)
=XLOOKUP(value, range, return_range)
=INDEX(range, row, column)
=MATCH(value, range, 0)
Date & Time =TODAY() – Current date
=NOW() – Current date & time
=DAY(date)
=MONTH(date)
=YEAR(date)
=DATEDIF(start, end, unit)
Financial =PMT(rate, nper, pv) – Loan payment
=FV(rate, nper, pmt) – Future value
Advanced =SUMIF(range, criteria, sum_range)
=COUNTIF(range, criteria)
=SUMIFS(sum_range, criteria_range, criteria)
=IFERROR(formula, value)

You might also like