IF FUNCTION- With multiple conditions |NESTED IF|NOT/AND/OR LOGICAL FUNCTIONS
In this video, I will show you how to use Excel IF function with multiple conditions. The IF function is one of the logical functions of Microsoft Excel that helps you evaluate certain conditions and returns a defined response when that condition is met and another when the condition is not met. Here, you will learn how to use the IF function with single condition, the NESTED IF function and the IF function with other EXCEL logical functions such as the NOT, AND & OR function. Go through my play list to learn other educative videos MICOSOFT EXCEL FOR INTERMEDIATE LEVEL: https://youtu.be/BJ8PKy6dtmc?si=z3ZKylERnYsnciwv https://www.youtube.com/playlist?list=PL5KFm9HsgsDe4UaJD9nf6JZgi8N_izK6s PIVOT TABLES | PIVOT CHARTS: https://www.youtube.com/playlist?list=PL5KFm9HsgsDd2n1EjQw5ooPVqbqFcxPNF MICOSOFT EXCEL FOR BEGINNERS VIDEO: https://www.youtube.com/playlist?list=PL5KFm9HsgsDeyHKOlfH0ZvcU068emF0Xi About This Channel: https://www.youtube.com/playlist?list=PL5KFm9HsgsDccCF-dQNw-mv63rwzfnAc6 EXCEL SHORTS: https://www.youtube.com/playlist?list=PL5KFm9HsgsDe50HRGwTwUFlaQ5wIm1WyE Click on the link below to access the template so you can practise along while watching. https://docs.google.com/spreadsheets/d/1LNbdsY_2r2cDUaTrhJP-hbqXSI_RY-nP/edit?usp=drivesdk&ouid=108977556217702238358&rtpof=true&sd=true The time stamps below will help you locate any specific area you are interested in. 0:00 -Intro 0:56 -Single condition of the IF function 2:56 -Conditional formatting 3:25 -Example 2 4:24 -NESTED IF function 11:00 -AND Logical function within the IF function 13:27 -OR Logical function within the IF function 15:14 -OR/AND Logical function 18:26 -NOT Function within the IF function 21:21 -Wrap up
Download
0 formatsNo download links available.