Скачать или смотреть 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:
   • PAYE COMPUTATION IN EXCEL |TAX TABLE | PAY...      • MICOSOFT EXCEL FOR INTERMEDIATE LEVEL  
PIVOT TABLES | PIVOT CHARTS:    • PIVOT TABLES | PIVOT CHARTS  
MICOSOFT EXCEL FOR BEGINNERS VIDEO:    • MICOSOFT EXCEL FOR BEGINNERS VIDEO  
About This Channel:    • About This Channel  
EXCEL SHORTS:    • Excel YouTube Shorts  
Click on the link below to access the template so you can practise along while watching.
https://docs.google.com/spreadsheets/...
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