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

wumolad's avatar
wumolad
Iron Contributor
Apr 25, 2020

Hi Kjlax 

 

Since the costs are in a column, using table will make the function works better. This also get updated for new entries.

 

You can create table by pressing CTRL+T.

 

Cheers

Resources