[go: up one dir, main page]
Scribd
Upload
47 views1 page

Excel Formulas

This document is a cheat sheet for Microsoft Excel formulas, providing a list of common functions along with their descriptions and examples. Key formulas include SUM, AVERAGE, MIN, MAX, and various text manipulation and date functions. It serves as a quick reference for users to perform calculations and data analysis in Excel.

Uploaded by

ahmadsaleem5898
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
47 views1 page

Excel Formulas

This document is a cheat sheet for Microsoft Excel formulas, providing a list of common functions along with their descriptions and examples. Key formulas include SUM, AVERAGE, MIN, MAX, and various text manipulation and date functions. It serves as a quick reference for users to perform calculations and data analysis in Excel.

Uploaded by

ahmadsaleem5898
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
You are on page 1/ 1

Microsoft Excel Formulas Cheat Sheet

Formula Description Example

=SUM(A1:A5) Adds values in range A1 to A5 SUM of 10,20,30 = 60


=AVERAGE(A1:A5) Calculates average AVERAGE of 10,20,30 = 20
=MIN(A1:A5) Finds minimum value MIN of 10,20,30 = 10
=MAX(A1:A5) Finds maximum value MAX of 10,20,30 = 30
=ROUND(3.14159,2) Rounds number to 2 decimals Result = 3.14
=CONCAT(A1, " ", B1) Joins text from cells Hello + World = Hello World
=LEFT(A1,4) Extracts leftmost 4 characters Ahmed → Ahme
=RIGHT(A1,3) Extracts rightmost 3 characters Saleem → eem
=LEN(A1) Counts number of characters Ahmed → 5
=TRIM(A1) Removes extra spaces Hello → Hello
=IF(A1>50,"Pass","Fail") Checks condition 70 → Pass
=AND(A1>10,B1<5) Checks multiple conditions TRUE/FALSE
=VLOOKUP(101,A2:D20,2,FALSE)
Finds value in table Search ID 101 in column A
=INDEX(A1:C10,2,3) Returns value from row 2, col 3 Cell C2
=MATCH(50,A1:A10,0) Finds position of 50 If 50 is in A5 → 5
=TODAY() Returns current date 09-09-2025
=NOW() Returns current date & time 09-09-2025 10:30
=DAY(A1) Extracts day from date 09-09-2025 → 9
=MONTH(A1) Extracts month from date 09-09-2025 → 9
=YEAR(A1) Extracts year from date 09-09-2025 → 2025
=UNIQUE(A1:A10) Returns unique values {5,10,15}
=SORT(A1:A10) Sorts values Ascending order
=FILTER(A1:B10,B1:B10>50) Filters data Only values > 50

You might also like