← Back to level 3
Level 3Next
CHOOSECOLS
A hard formula used by students to solve a real worksheet task with CHOOSECOLS.
Syntax
=CHOOSECOLS(...)Step-by-step explanation
- 1Understand the job that CHOOSECOLS solves before you type the formula.
- 2Build or select the cells and ranges that CHOOSECOLS needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Choosing the wrong input cells
Forgetting to press Enter
Copying a formula without checking the references
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 96 |
Formula
=CHOOSECOLS(A1:B2)
Result
Advanced output
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =CHOOSECOLS(A1:B2) in the result cell and press Enter.
- 3Check that the output matches Advanced output.
Practice area
Practice CHOOSECOLS on a small workbook scenario and confirm the result yourself.
Match against the syntax block above.