I need some help to do something…
1/I have a column with a price
2/ I have a column with a Single Select option, and a list of discounts (10%,15%,20%,30%)
I would like to create a 3rd column, with a formula which gives me the total discounted price, based on the discount which has been selected.
So if : Column B has a total of $100
Column C has 10% selected
The new column D should show me $90
I don’t know how to create a formula which will calculate the discounted amount based on the selected field.
I would be great to have some help on that!