|
Featured Tutorial
Featured Macro
Highline Excel Class 46: CHOOSE function 4 Examples
See 4 examples for the CHOOSE function:
1.Randomly CHOOSE names (where value is "text" (in quotes))
2.VLOOKUP with 3 three tables. Select Table for VLOOKUP with CHOOSE, where the value is a defined name (could be range or cell)
3.Use CHOOSE for Survey Results (Choose rounds down number to integer)
4.Use CHOOSE to choose function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
1.Randomly CHOOSE names (where value is "text" (in quotes))
2.VLOOKUP with 3 three tables. Select Table for VLOOKUP with CHOOSE, where the value is a defined name (could be range or cell)
3.Use CHOOSE for Survey Results (Choose rounds down number to integer)
4.Use CHOOSE to choose function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109