Forum Discussion

Kjlax's avatar
Kjlax
Copper Contributor
Apr 25, 2020
Solved

Attempting to apply discount formula to column of data

Right now I have a excel sheet with 2800+ different data points (Current Cost) in a column. Currently I have the percentage in its own cell (L10) so that I'm able to change it and have it adjust the ...
excel
Formulas and Functions
  • wumolad's avatar
    wumolad
    Apr 25, 2020

    Kjlax 

     

    Check the updated version with table and another column (Disc Cost) in column J.

     

    Hope this helps

Kjlax's avatar
Kjlax
Copper Contributor
Apr 25, 2020

The data is already listed out in a column, but hoping to apply a formula. But the problem I'm running into is that there is part of the formula (cost) that changes in every cell. So I'm trying to apply the formula without having to change the data that's already provided. But yes, I would like to apply the formula to the entire column.

I'll attach the file to explain better. On the second sheet, the percentage is in cell L10, and I would like to apply the formula to column F in cells 9-2885. With the current formula being "(Cost)*(1-L10)" 

wumolad's avatar
wumolad
Steel Contributor
Apr 25, 2020

Hi Kjlax 

 

You should create another column where you will list out the column and then apply the formula to show the cost column * (1-L10) instead of hardcoding the costs in the formula.