Scribd
Upload
10 views1 page

Excel Formulas Guide

This document provides a guide to essential Excel formulas, including functions for summing, averaging, counting, and logical conditions. It also covers lookup functions, text manipulation, and date/time functions. Each formula is presented with a brief description and example syntax.

Uploaded by

adeelm052
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
10 views1 page

Excel Formulas Guide

This document provides a guide to essential Excel formulas, including functions for summing, averaging, counting, and logical conditions. It also covers lookup functions, text manipulation, and date/time functions. Each formula is presented with a brief description and example syntax.

Uploaded by

adeelm052
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 Guide

1. SUM: =SUM(A1:A10) – Adds numbers in a range.

2. AVERAGE: =AVERAGE(A1:A10) – Calculates average.

3. COUNT: =COUNT(A1:A10) – Counts numeric values.

4. COUNTA: =COUNTA(A1:A10) – Counts non-empty cells.

5. IF: =IF(A1>50, "Pass", "Fail") – Logical condition.

6. VLOOKUP: =VLOOKUP(A2, A1:D10, 2, FALSE) – Vertical lookup.

7. HLOOKUP: =HLOOKUP(A2, A1:D10, 2, FALSE) – Horizontal lookup.

8. XLOOKUP: =XLOOKUP(A2, A1:A10, B1:B10) – Modern lookup function.

9. CONCAT: =CONCAT(A1, B1) – Combines text.

10. LEFT: =LEFT(A1, 4) – Extracts text from left.

11. RIGHT: =RIGHT(A1, 4) – Extracts text from right.

12. MID: =MID(A1, 2, 3) – Extracts text from middle.

13. LEN: =LEN(A1) – Counts characters.

14. ROUND: =ROUND(A1, 2) – Rounds numbers.

15. TODAY: =TODAY() – Returns current date.

16. NOW: =NOW() – Returns current date & time.

You might also like