CHOOSE Function (Gnumeric)

The worked formula below shows the argument order used for this example. Consult the linked software-specific function reference for optional parameters and edge cases.

Gnumeric formulas normally use commas (,) between arguments. These examples are written for Gnumeric rather than copied unchanged from LibreOffice Calc.

=CHOOSE(2,"Low","Medium","High")

Expected result: Medium.

Why it works: Choose the second value from a supplied list.

Practice inputs: No worksheet cells are required.

=CHOOSE(1,"Red","Blue")

Expected result: Red.

Index 1 selects the first value. This can turn numeric codes into friendly categories.

What to watch for

CHOOSE uses a 1-based index, and exceeding the number of choices produces an error.

For LibreOffice Calc formulas, separators are commonly semicolons; the Gnumeric examples here use commas. The arithmetic or official reference supplies the expected result, but Gnumeric has not been executed for this review.

• Gnumeric lookup function documentation

1. Identify the cells or inputs that correspond to the sample values above.
2. Enter the formula in an empty cell, changing the references or literal values to match your sheet.
3. Compare the output with a manual check on a small known example.
4. Extend the formula to a larger dataset only after you understand the result.

• Use the correct lookup column or return range, and use exact-match options where appropriate.
• Check for duplicate keys, leading spaces and numbers stored as text in lookup data.
• A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.

VLOOKUP HLOOKUP MATCH INDEX ROW.

• Gnumeric official function reference
• Gnumeric function catalog
• The function name was checked against the official reference. A comparable example passed in LibreOffice Calc 25.2, but the example was not executed in this application. Confirm on your installed version before depending on it.