How to Use the CHOOSE Function in WPS on Windows

This section includes 4 how-to topics for the CHOOSE function, all available without membership, so you can jump from the index to the task you need.

How-to Index

How-to Guide

1. Enter the CHOOSE function

Entry point: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to begin the formula.
3. Type CHOOSE(.
4. Check the syntax hint that appears.

Success Criteria

• Interface result: CHOOSE( appears in the formula bar or selected cell.
• Next step available: You can continue entering the index and candidate arguments.

Tips While Using

• Start the formula with =.
• It is helpful to continue after the syntax hint appears so you can confirm the structure.

2. Fill in the parameters

Entry point: formula bar

1. After CHOOSE(, enter the index argument first.
2. Continue entering candidate values or cell references, separated correctly.
3. Check that the parentheses are complete.
4. Press Enter to confirm the formula.

Success Criteria

• Interface result: The cell returns the expected calculation result.
• Next step available: You can select the cell again to review or edit the formula.

Tips While Using

• Make sure the number and order of arguments match your intended result.
• If an error appears, first check the parentheses, separators, and index position.

3. Use cross-worksheet references

Entry point: formula bar + worksheet tabs

1. Enter a CHOOSE formula in the target cell.
2. Move to another worksheet while placing the candidate arguments.
3. Select the cell or range you want to reference.
4. Return to the current sheet and confirm the formula.

Success Criteria

• Interface result: The formula includes content referenced from another worksheet.
• Next step available: When the referenced cell changes, the result can update accordingly.

Tips While Using

• Confirm that the worksheet name and referenced cell position are correct.
• If the referenced content changes significantly, review the returned result again.

4. Build nested calculations

Entry point: formula bar

1. Decide which candidate results CHOOSE should return.
2. Add other functions or references inside the candidate arguments.
3. Check the nesting levels and parentheses structure.
4. Press Enter to complete the calculation.

Success Criteria

• Interface result: The cell shows the result of the nested calculation.
• Next step available: You can continue extending the formula with other functions.

Tips While Using

• If the formula becomes long, edit it in the formula bar.
• If the result looks wrong, review each nested layer step by step.