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

Комментарии

Информация по комментариям в разработке

Похожие видео