1. =AND( )
    AND function returns to when all condition are satisfied or fulfilled. It return TRUE if all conditions are true and returns FALSE if any of the conditions are false.

Example: 1

Example: 2


2. OR( )
    It returns TRUE when at least one condition is true and returns FALSE if all conditions are false.



3. NOT( )
    It return TRUE when condition is false and vice-versa



4. IF( )
    IF function is used to taking decision there are 2 type of IF
    1. Single if
    2. Nexted if
    1) Single IF
        Single if statement is use to take a single decision from two option.


    2) Nexted IF
        Nexted if statement is use to take a single decision from multiple option.