EXCEL FORMULAS

*10 EASY MS EXCEL FORMULAS:-

1.)SUM:-  =SUM(B9+C8+G6)

2.) MAXIMUM:-  =MAX(B2:B3)

3.)  MINIMUM:-  =MIN(B2:B3)

4.) COUNT:-  =COUNT(B2:B3:B4){ THIS COUNT ONLY NUMBER }

5.) COUNTA:-  =COUNTA(B2:B3:B4:B5) { THIS COUNT ALL .e.g. NUMBER , ALPHBET}

6.)COUNTIF:-  =COUNTIF(GREATER<70,LESS>35)

7.)AVERAGE:-  =AVERAGE(TOTAL/SUBTOTAL*100)

8.)EXPONENTS:-  =EXPONENTS(VALUE1^VALUE2)

9.)EXACT:-  =EXACT(VALUE1,VALUE2)

10.)SUMIF:-  =RANGE,CRITERIA,[SUM_RANGE])