Excel Battle: IF vs IFS

Which Microsoft Excel function is better, IF or IFS? In this video, we'll put these two functions into a 3 round main event. We will examine these key differences:
1 - Arguments and syntax
2 - Multiple conditions
3 - Default value


Chapters in this video:
00:00 - Introduction
00:13 - Main Event
00:33 - Round 1
02:00 - Round 2
04:35 - Round 3

[WaldoHazeleger]

Nested IF can often be avoided by using IF AND, like: =IF(AND(C12="Y", D12="Y"), 500, 0)

[PaulEBrownbill]

Thanks for the comparison, very interesting and informative. Paul

[detectivethinker]

This video has helped me a lot. Basically, with the IF you need to nest it after hitting the first criterium, whereas with IFs you just type whatever shows up. Initially, I have struggled with this, but I am getting to grips with this now. Thank you so much for the tutorial! It has made an academic lesson very engaging.

[ikadconsultancytraining]

Nested IF is more structered when there are many conditions to check, but for 2 or 3 conditions the IF is better