Scribd
Upload
7 views

excel notes

The document is a cheat sheet for Excel formulas, categorized into sections such as Basic Arithmetic, Statistical Functions, Logical Functions, Text Functions, Date & Time Functions, Lookup & Reference Functions, Financial Functions, Rounding Functions, and Miscellaneous. Each section provides specific formulas with brief explanations of their functions. This resource serves as a quick reference for users to efficiently utilize Excel's capabilities.

Uploaded by

Poornima Vr
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
7 views

excel notes

The document is a cheat sheet for Excel formulas, categorized into sections such as Basic Arithmetic, Statistical Functions, Logical Functions, Text Functions, Date & Time Functions, Lookup & Reference Functions, Financial Functions, Rounding Functions, and Miscellaneous. Each section provides specific formulas with brief explanations of their functions. This resource serves as a quick reference for users to efficiently utilize Excel's capabilities.

Uploaded by

Poornima Vr
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
You are on page 1/ 2

Excel Formulas Cheat Sheet

1. Basic Arithmetic Formulas

 =A1 + B1 → Addition

 =A1 - B1 → Subtraction

 =A1 * B1 → Multiplication

 =A1 / B1 → Division

 =A1 ^ B1 → Exponentiation

2. Statistical Functions

 =SUM(A1:A10) → Adds all values in the range

 =AVERAGE(A1:A10) → Calculates the mean

 =MAX(A1:A10) → Returns the highest value

 =MIN(A1:A10) → Returns the lowest value

 =COUNT(A1:A10) → Counts numeric entries

 =COUNTA(A1:A10) → Counts all non-empty cells

 =COUNTIF(A1:A10, ">50") → Counts cells meeting a condition

3. Logical Functions

 =IF(A1>50, "Pass", "Fail") → If condition is met, return "Pass", otherwise "Fail"

 =IF(AND(A1>50, B1<100), "OK", "Not OK") → Returns "OK" if both conditions are true

 =IF(OR(A1>50, B1<100), "OK", "Not OK") → Returns "OK" if either condition is true

 =IFERROR(A1/B1, "Error") → Returns "Error" if there’s a division error

4. Text Functions

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

 =RIGHT(A1, 3) → Extracts last 3 characters

 =MID(A1, 2, 4) → Extracts 4 characters from position 2

 =LEN(A1) → Returns the length of the text

 =TRIM(A1) → Removes extra spaces

 =CONCAT(A1, B1) or =A1 & B1 → Joins text

 =SUBSTITUTE(A1, "old", "new") → Replaces "old" with "new"

5. Date & Time Functions

 =TODAY() → Returns the current date

 =NOW() → Returns the current date and time


 =YEAR(A1) → Extracts the year from a date

 =MONTH(A1) → Extracts the month

 =DAY(A1) → Extracts the day

 =DATEDIF(A1, B1, "Y") → Calculates the difference in years

6. Lookup & Reference Functions

 =VLOOKUP(lookup_value, table_array, col_index, FALSE) → Searches vertically

 =HLOOKUP(lookup_value, table_array, row_index, FALSE) → Searches horizontally

 =INDEX(A1:C3, 2, 3) → Returns the value at row 2, column 3

 =MATCH(50, A1:A10, 0) → Finds the position of 50 in the range

7. Financial Functions

 =PV(rate, nper, pmt) → Calculates the present value

 =FV(rate, nper, pmt) → Calculates future value

 =PMT(rate, nper, pv) → Calculates loan payments

8. Rounding Functions

 =ROUND(A1, 2) → Rounds to 2 decimal places

 =ROUNDUP(A1, 2) → Rounds up

 =ROUNDDOWN(A1, 2) → Rounds down

 =INT(A1) → Removes decimals

9. Miscellaneous

 =RAND() → Generates a random number between 0 and 1

 =RANDBETWEEN(1, 100) → Generates a random number between 1 and 100

 =ABS(A1) → Returns the absolute value

 =MOD(A1, B1) → Returns the remainder of division

You might also like