Run Different Excel Calculations Based on a Drop-Down Selection
Question details
Use a drop-down selection to determine which calculation a spreadsheet performs.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to select a numeric option from a drop-down list and calculate a result from another cell.
- Observed behavior
- The formula should apply the calculation associated with the selected option.
Choose distinct values for each drop-down option and decide which calculation each value should trigger. In this example, A1 holds the selection and B1 holds the amount.
Use a Drop-Down List with a Nested IF Formula
Use this method to apply one of two calculations based on a numeric selection.
Select cell A1, open Data > Data Validation, and choose List under Allow.
In the Source box, enter 1,2 and click OK. Select either 1 or 2 from the drop-down in A1.
Type the amount to calculate in cell B1.
In C1, enter =IF(A1=1,B1*10%,IF(A1=2,B1*15%,0)). Option 1 calculates 10% of B1, option 2 calculates 15%, and any other value returns 0.
Use the drop-down in A1 to switch between 1 and 2 and check the result in C1. Replace the percentages or calculations in the formula with the ones you need.

Create Drop-Down Calculations in WPS Spreadsheet
Use data validation and an IF formula in WPS Spreadsheet to calculate different results from a drop-down choice.
- 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an Excel file.
- 2. Add the drop-down: Select A1, open Data > Data Validation, choose List, and enter 1,2 as the source.
- 3. Enter an amount and formula: Type an amount in B1, then enter =IF(A1=1,B1*10%,IF(A1=2,B1*15%,0)) in C1.
- 4. Check the result: Choose 1 or 2 from the drop-down in A1 and verify the corresponding result in C1.

Frequently Asked Questions
Can I use text labels instead of numbers in the drop-down?
Yes. Enter labels such as Standard and Premium in the Data Validation list, then use a formula such as =IF(A1="Standard",B1*10%,IF(A1="Premium",B1*15%,0)).
Why can't Excel treat 10% and 0.1 as different choices?
Both represent the same numeric value in Excel, regardless of how they are displayed. Use distinct text labels or identifiers when the choices need different formulas.
How do I add another calculation to the formula?
Add another value to the Data Validation list in A1, then add another IF condition before the final 0 in the formula. For many options, consider IFS or SWITCH if your Excel version supports them.
What happens if A1 is blank or contains an unexpected value?
The example formula returns 0 because neither condition matches. Replace the final 0 with another result, such as "Select an option", if you prefer a message.




