Scribd
Upload
23 views2 pages

Excel Formulas: Basics to Advanced

The document provides a comprehensive list of basic and advanced Excel formulas. Basic formulas include SUM, AVERAGE, and IF, while advanced formulas feature VLOOKUP, INDEX, and XLOOKUP. Each formula is accompanied by its syntax for easy reference.

Uploaded by

Rajeev Parashar
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
23 views2 pages

Excel Formulas: Basics to Advanced

The document provides a comprehensive list of basic and advanced Excel formulas. Basic formulas include SUM, AVERAGE, and IF, while advanced formulas feature VLOOKUP, INDEX, and XLOOKUP. Each formula is accompanied by its syntax for easy reference.

Uploaded by

Rajeev Parashar
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

Excel Formulas - Basic and Advanced

Basic Excel Formulas

Basic Excel Formulas:

1. SUM: =SUM(A1:A10)

2. AVERAGE: =AVERAGE(B1:B10)

3. COUNT: =COUNT(C1:C10)

4. COUNTA: =COUNTA(D1:D10)

5. IF: =IF(E1>10, "Yes", "No")

6. MIN: =MIN(F1:F10)

7. MAX: =MAX(G1:G10)

8. CONCATENATE: =CONCATENATE(H1, " ", H2)

9. TODAY: =TODAY()

10. NOW: =NOW()

11. LEN: =LEN(I1)

12. TRIM: =TRIM(J1)

13. LEFT: =LEFT(K1, 3)

14. RIGHT: =RIGHT(L1, 2)

15. MID: =MID(M1, 2, 4)

Advanced Excel Formulas

Advanced Excel Formulas:

1. VLOOKUP: =VLOOKUP(N1, A1:B10, 2, FALSE)

2. HLOOKUP: =HLOOKUP(O1, A1:Z2, 2, TRUE)

3. INDEX: =INDEX(A1:C10, 2, 3)
Excel Formulas - Basic and Advanced

4. MATCH: =MATCH(20, A1:A10, 0)

5. INDIRECT: =INDIRECT("A" & P1)

6. OFFSET: =OFFSET(Q1, 3, 1)

7. SUMIF: =SUMIF(A1:A10, ">10", B1:B10)

8. COUNTIF: =COUNTIF(B1:B10, ">5")

9. IFERROR: =IFERROR(1/0, "Error")

10. TEXT: =TEXT(R1, "MM/DD/YYYY")

11. CHOOSE: =CHOOSE(2, "Apple", "Banana", "Cherry")

12. ARRAYFORMULA: =ARRAYFORMULA(A1:A10 * B1:B10)

13. XLOOKUP: =XLOOKUP(S1, A1:A10, B1:B10)

14. FILTER: =FILTER(A2:A10, B2:B10>5)

15. UNIQUE: =UNIQUE(A1:A10)

You might also like