How to syntax and use Top 16 Excel Functions
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.