Excel Examples: AND, IF, OR & NOT Functions

In this video tutorial you will see use of a bunch of Excel functions like IF, AND, OR & NOT. Basically three examples given in the video-

1) NOT function explained with example, 

2) IF Function & AND Function used to check eligibility to applying for a govt. job, 

3) IF Function, OR Function & NOT Function used to check eligibility to enter in a Party. 

NOT FUNCTION

NOT Function used for revert the result of logical test. It convert TRUE to FALSE & FALSE to TRUE.

For example, if youi want to check the eligibility for applying for a government job with the following crietria- 

1) Age should be greater than or equal to 18.

2) Age should be less than or equal to 35,

3) Percent of marks should be greater than or equal 50%. 

If the three parameter get matched then result will be as “Yes”, and if one of the parameter doesn’t match then result will be “No”.