Apply a discount to multiple columns

[Kmahraz]

Hi:
I am looking for a way to apply a discount to multiple columns. Each time I change my discount the values of the columns will need to change automatically.
any help will be much appreciated.
Sample file attached.

Thank you!
K

 

[shrivallabha]

Hi Kareem,

I am not sure to which columns you need to apply the discount but assuming that you need to implement it from D5, in D5 write following formula and copy down and across.
=C5*(1-$B$2)

 

[Kmahraz]

Hi Shrivallabha
Thank you for the suggestion, I used the same formula and applied it to all columns.
Much appreciated
Karim