Forum Discussion
marturzyca
Jan 24, 2024Copper Contributor
Can I use a formula based on a text from a drop down list in a different cell?
Hi, I have created an invoice template with a drop down list for chargeable items. I would like to have a formula which would calculate the value based on the drop down selection. I have tried to use =CHOOSE(MATCH... formula but it's not working.
I created the drop down list using data validation, data is sourced from a separate worksheet within the file. Drop down has the following text options to choose from:
- 5% deposit
- 50% deposit
- 45% balance
If I choose one of the above in cell A2, enter a value in cell A1, I would like a calculation to happen in cell B2 that will calculate 5%, 50% or 45% of A1 based on the selection in A2.
Any ideas welcome.
Many thanks
2 Replies
Sort By
- marturzycaCopper ContributorI think I've fixed it, tried =CHOOSE(MATCH(... again and it's working. I must have had an error in the formula earlier.
- Harun24HRBronze Contributor
marturzyca What this simple formula?
=A1*A2
And below if you have texts with percentage value.
=TEXTBEFORE(E2," ")*E1