IF Function Excel With Multiple Conditions | Nested IF, IFS Function | IF with 2 or More Conditions
Рет қаралды 3,929
Күн бұрынDownload the featured file here: www.bluepecantraining.com/wp-...
In this Microsoft Excel video tutorial I explain how to use the IF function with multiple conditions. You have two functions that can achieve this: the IF function & the IFS function. In some scenarios, however, VLOOKUP is a more efficient route to take.
🕰️Timestamps
00:00 Introduction
00:05 Method 1: Nested IF method for multiple conditions
02:07 Method 2: IFS function method for multiple conditions
03:09 Method 2 cont: IFS Using TRUE
04:35 Method 3: Use VLOOKUP instead of IF (most efficient)
#exceltutorial #exceltips
@desleybettens5356 23 күн бұрын
You made that so easy to understand. Thank you mate.
@michaeliverson8464 7 ай бұрын
I LOVE a good IFS formula!
@alexrosen8762 7 ай бұрын
Very important and therefore useful tutorial 👌
@silviopoggi8193 7 ай бұрын
Always wonderful information presented so clearly. Thank you for your continued time commitment and efforts. Cheers!
@ChesterTugwell 7 ай бұрын
Glad you found it useful.
@skip031890 7 ай бұрын
I love "if" statements.
@amarmanhas8432 7 ай бұрын
Do you have any course so that we can learn all the excel skills
@Jojosmith342 7 ай бұрын
all thumbs up to the greatest Excel teacher Chester. Already subscribed. Hope everyone would please subscribe too for Chester's hard work. Thank you very much for teaching us Chester
MyOnlineTrainingHub
Рет қаралды 325 М.
Rebekah Oster
Рет қаралды 31 М.
Chester Tugwell
Рет қаралды 69 М.
Lander Art
Рет қаралды 24 МЛН
Pochinka_blog
Рет қаралды 2,9 МЛН