In the Starting of Logical Function, first I am going to introduce about first 4 Logical Functions that will help to understand the logical output, and these 4 Functions are #OR, #AND, #XOR, #NOT. First 3 #OR, #AND, #XOR Functions test multiple conditions at the same time and returns either TRUE or FALSE, and last #NOT Function returns the opposite of a given logical value.
If you are going to use next Logical Function #IF, before that you should to know about all these 4 functions.

To Know more watch this video till the end

Introduction of Logical Function
https://youtu.be/-ZB0s2OxOwc

Excel Lookup & Reference Functions Videos
https://www.youtube.com/playlist?list=PL5aHL_PWWkL4PRATSxp9FpplQ2RfZwkia

Excel Logical Functions
#AND function in excel
#OR function in excel
#NOT function in excel
#XOR function in excel