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...
Harun24HR
Jan 24, 2024Bronze Contributor
marturzyca What this simple formula?
=A1*A2
And below if you have texts with percentage value.
=TEXTBEFORE(E2," ")*E1