CHOOSE is one of those Excel functions that may not seem to be useful on its own, but when combined with other functions it reveal its true potential.
At the most basic level, you use the CHOOSE function to get a value from a list by specifying the position of that value. Gradually in this tutorial, you will find several advanced uses that are certainly worth learning. So lets explore the CHOOSE function and see how it can replace the nested IFs & finding data on the left of lookup value in the table array using the VLOOKUP formula. Moreover, we will also see how we may custom format the dates by using the CHOOSE formula instead of using the custom cell formatting.
Timeline:-
00:00 - Intro
00:52 - Basic CHOOSE Function
03:27 - Nested IF
05:41 - CHOOSE instead of Nested IF 1
08:20 - Understanding Advance CHOOSE
09:55 - CHOOSE instead of Nested IF 2
12:25 - RANDBETWEEN & CHOOSE func.
13:23 - CHOOSE & VLOOKUP
15:12 - Custom Day / Month Name
17:02 - Wrap up
#microsoftexcel #excel tutorial # excel
Негізгі бет Excel CHOOSE Function Multiple Conditions
Пікірлер: 4