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

[sharifmdhasan]

SHOCKINGLY BEST ICT TEACHER EVER- (RESPECT, LOVE AND ADMIRATION COMING FROM SAUDI ARABIA)

[adammahmoud]

THANK YOU SO MUCH YOU SAVED ME 1 DAY BEFORE MY EXAM

[adammahmoud]

THANK YOU SO MUCH YOU SAVED ME THE NIGHT BEFORE MY EXAM

[theonenonlymystic]

ty tumz is my exam you explained it very well you the best

[audcharlotteullestad]

This was exciting. You explain simply, well and neatly. Thank you for sharing.

[InsightfulLife]

really helpful, very well explained and very quick learnt it

[uxyibxi]

thank sir it helped me before exam my ict boards of fem/march is today

[furpdtn]

TO the point with necessary details, I've recommended this as top 1 to all my friends. I have a question tho, how do i know whether i should use a nested IF function or an IFS function?

[areejfatima-txjc]

Sir I have a few questions;

1) Sir how do we know where in the paper we are required to use the IF, Nested IF or the IFS function?

2) Secondly, sir what is the Sum IF Function?

3) Do you have any guess for IGCSE 0417 P3 taking place on 18th April, 2024?

[daniyalkhalid]

Really Helpful but ineed to know that if we have watched all your videos do we attempt some papers

if we have an exam tomorrow

[gandalfthewhite]

Sir we could have used lookup in the question instead of the nested IF function if am right

[trappyshekar_ZA]

Hi Mr.paphitis can you link those excel sheets so we can practice as well

[TaherSaigar]

cant u use lookup function instead surely it has to be quicker

[akahassi]

Sir the IFS function and XLookup functions are optional right?

[raniariffat]

how do we know when to put logic operators and numbers in speech marks? at 10:48 if you see the function in E4, it has no speech marks so im getting confused

[savagex_]

Has there been a question where only IFS statement could be used and not the IF

[gs]

teacher do you mind checking your mail please, I have asked you something in there