Hi,

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!

Thanks,

Sébastien