Mathematical formula based on drop-down list

Hi, In one cell I have a dropdown list with 2 options (Numbers). And based on the on user choice on that dropdown list. I want a mathematical calculation to trigger using the number in the drop-d...

excel

Formulas and Functions

office 365

Rossi_Seepersad
Feb 21, 2023
Update: I was able to get the calculation to fire how I wanted it. Detlef_Lewin I formatted the two rows for the dropdown as numbers. However, I ran into the issue of excel seeing 0.1 and 10% as the same number in the calculation so it was throwing off the "if" logic. I needed the decimal row to be true in the "if" function and percentage to be false. To get around this I added extra zeroes to the decimals followed by a one and formatted the cells so it only displays two digits.

The function I used was "if" and "or". For "or" I put in all the possibilities to make the "if" statement true. So far this seems to be working as expected. If anyone sees any issues with this or knows of a simplified calculation, let me know.

Rossi_Seepersad

Copper Contributor

Feb 20, 2023

The drop-down list is dependent on another list. So the value is constantly changing. If I were to use choose and if function, I would need to create a calculation for every time a certain number is chosen. I was checking if there was another way to do this. I am not familiar with the switch function.