How to Write a Nested IF Function in Excel with Multiple Conditions
If you have formulas that contain multiple nested if conditions, such as =IF(A1=1;"A";IF(A1=2;"B";IF(A1=3;"C";IF(A1=4;"D";IF(A1=5;"E";IF(A1=6;"F";""))))))
then I invite you to stop this because we're going to see together how to use two functions that allow us to do the same thing but more cleanly.
In this video, we'll cover the following functions:
00:00 Intro
00:21 IF.Conditions function
02:48 IF.Multiple function
05:08 CHOOSE function
Join this channel to enjoy exclusive benefits:
/ @tutoderien
#TutoDeRien
Website: https://www.tutoderien.com
Subscribe to the channel and we'll see you again for the next video.