Скачать с ютуб Excel IF functions explained: IF, Nested IF, and the new IFS function [IGCSE ICT 0417] в хорошем качестве

Excel IF functions explained: IF, Nested IF, and the new IFS function [IGCSE ICT 0417]

Learn all about the IF functions. From basic IF function to Nesting an IF into another IF and finally covering the all new IFS function. This tutorial explains how the IF functions work and demonstrates the functions with working examples. The tutorial covers all the IF functions required for the Cambridge ICT 0417 practical exam paper 3. 0:00 Introduction 0:48 IF function Explained 5:20 Logical operators 6:34 IF Function examples 15:12 Nested IF Functions Explained 22:41 Sample Nested IF Function (3 tier) 28:32 Only the IF Function returns a value if False 29:50 IFS Function (#N/A) error if logical test is False 32:58 IFS Function, multiple logic tests 34:53 Sample IFS Functions