assigning same percentage discount to four different columns with different prices

I have a question. I am setting up an cost estimating spreadsheet. I have the same product prices configured 6 different ways on six columns with multiple rows also configured differently. I want to apply the same discount, per example a 10% discount to all six columns and rows. I created five columns with 10, 15, 20, 25 and 30 percent discount. I wanted to configure the 10% discount to show for each cell on the 10% column. For example:

FOR 10% DISCOUNT:

Column H, row 217, cell H217 / to show 10% discount on column Q cell Q217 (column Q is 10%, column R is 15%, and so on up to 30% in 5%'s increments.)

Column I row 218, cell I218 / to show 10% discount on column Q cell Q218

FOR 15% DISCOUNT:

Column H, row 217, cell H217 / show 15% discount on column R cell R217

Column I row 218, cell I218 / show 15% discount on column R cell R218

and so forth. Need to do that in order not to create too many columns like:

a column for 10% for prices on columns H

10% discount for prices on column I

10% discount for prices on column J

15% discount for prices on column H

15% discount for column I

15% discount for column J

You get my idea.

Is that possible to do? I am not too fluent in Excel so I am doing this the hard way, try an error.

Any help will be appreciated.

Thank you.