FORMULAS IN EXCEL

                                      FORMULA BAR

Functions are predefined formulas that perform calculations on specific values,  called arguments. Each function takes specific types of arguments, such as text, numbers, logical values, references etc.  

You can enter the arguments, enclosing them in parentheses. i.e ( ) after the function name.

Excel includes many functions that can be divided into the following categories :-
                    

                      MATHEMATICAL FUNCTION 

1.SUM ()
2.ROUND()
3.ROUNDDOWN()
4.ROUNDUP()
5.ABS N()
6.SQRT()
7.TRUNC()
8.SUM IF()
9.ODD()
10.EVEN()
11.POWER()




                     

                          LOGICAL FUNCTION 

1.IF 

2.TRUE 

3.FALSE 

                                     

                         STATISTICAL FUNCTION 

1.MAX()

2.MIN()

3.AVERAGE()

4.COUNT()

5.COUNTIF()

  

                          DATE & TIME  FUNCTION 

           

1.TODAY()
2.NOW()
3.DAY()
4.MONTH()
5.YEAR ()
                         

                            TEXT  FUNCTION 

1. CONCATENATE()
2. LFET
3. RIGTH()
4. DOLLAR()
5. LOWER()
6. UPPER()
7. PROPER()
8.LEN()
9.REPLACE
10.MID()

                                         

                     LOOKUP FUNCTION 

1.HLOOKUP()
2.VLOOKUP()
3.TRANSPOSE()
4.ROW()
5.COLUMN()
6. HYPERLINK()


👉 We brief the formulas with Examples .........To be Continue in our  next blog.