Scribd
Upload
21 views2 pages

Excel

This document provides a comprehensive overview of various Excel formulas categorized into basic, logical, lookup & reference, text & string, date & time, financial, and error handling formulas. Each category includes specific formulas with brief explanations of their functions. The content serves as a quick reference guide for users to efficiently utilize Excel's capabilities.

Uploaded by

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

Excel

This document provides a comprehensive overview of various Excel formulas categorized into basic, logical, lookup & reference, text & string, date & time, financial, and error handling formulas. Each category includes specific formulas with brief explanations of their functions. The content serves as a quick reference guide for users to efficiently utilize Excel's capabilities.

Uploaded by

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

📌 Excel Formulas - Quick Notes

🔹 Basic Excel Formulas

 =SUM(A1:A5) → Adds values in a range


 =AVERAGE(A1:A5) → Calculates the average
 =MIN(A1:A5) → Returns the smallest number
 =MAX(A1:A5) → Returns the largest number
 =COUNT(A1:A5) → Counts numerical values
 =COUNTA(A1:A5) → Counts non-empty cells

🔹 Logical Formulas (IF Statements & Conditions)

 =IF(A1>50, "Pass", "Fail") → Checks if A1 is greater than 50


 =IF(AND(A1>50, B1>60), "Yes", "No") → Checks multiple conditions
 =IF(OR(A1>50, B1>60), "Yes", "No") → Returns "Yes" if at least one condition is
true

🔹 Lookup & Reference Formulas

 =VLOOKUP(101, A2:B10, 2, FALSE) → Finds a value in a table (Vertical Lookup)


 =HLOOKUP(101, A1:J2, 2, FALSE) → Finds a value in the first row (Horizontal
Lookup)
 =INDEX(A2:C5, 2, 3) → Returns value from a specific row & column
 =MATCH(50, A1:A10, 0) → Finds the position of a value in a range

🔹 Text & String Formulas

 =LEFT(A1, 3) → Extracts first 3 characters


 =RIGHT(A1, 4) → Extracts last 4 characters
 =MID(A1, 3, 2) → Extracts 2 characters from the 3rd position
 =LEN(A1) → Counts characters in a cell
 =TRIM(A1) → Removes extra spaces
 =CONCATENATE(A1, " ", B1) → Merges A1 & B1 with space
 =TEXT(A1, "MM/DD/YYYY") → Formats numbers/dates

🔹 Date & Time Formulas


 =TODAY() → Returns today's date
 =NOW() → Returns current date & time
 =DAY(A1) → Extracts the day from a date
 =MONTH(A1) → Extracts the month
 =YEAR(A1) → Extracts the year
 =DATEDIF(A1, B1, "Y") → Calculates difference in years

🔹 Financial Formulas

 =PV(5%, 10, -1000) → Calculates Present Value


 =FV(5%, 10, -1000, 0, 1) → Calculates Future Value
 =PMT(5%/12, 60, -30000) → Monthly loan payment
 =RATE(60, -500, 25000) → Finds interest rate

🔹 Error Handling Formulas

 =IFERROR(A1/B1, "Error") → Avoids division errors

You might also like