ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

How to syntax and use Top 16 Excel Functions

How to syntax and use Top 16 Excel Functions

Watch the video on YouTube


Syntax
1. =SUM(F8:F13)

2. =AVERAGE(F8:F13)

3. =ROUND(F8,2)

4. =MIN(F8:F13)

5. =MAX(F8:F13)

6. =COUNT(F8:F13)

7. =INDEX(I8:J13,3,2)

8. =MATCH(H8,I8:I13,0)

9. =VLOOKUP(H8,I8:J13,2,FALSE)

10. =HLOOKUP(H8,N7:S8,2,0)

11. =XLOOKUP(H8,I8:I13,J8:J13)

12.=COUNTIF(F8:F13,”>5″)

13. =COUNTA(F8:F13)

14. =SUMIF(F8:F13,”>5″)

15. Example 1 =IF(SUM(F8:F13)>10,”Sum is greater than 10″)
15. Example 2 =IF(SUM(F8:F13)>10, IF(SUM(F8:F13)<25, “Sum is greater than 10 and smaller than 25”, “”), “”)

16. =AVERAGEIF(F8:F13,”>5″)

Excel and Video credit: Tryfon Papadopoulos

Views: 3

Comments are closed.

Pin It