Forum Discussion
Attempting to apply discount formula to column of data
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)"
Check the updated version with table and another column (Disc Cost) in column J.
Hope this helps
Yes, that better accomplished what I was intending. But could you explain what the function you used to accomplish this?
"=+[@Cost]*(1-$L$10)"
I'm not bad with excel I'm just not used to using the shortcuts and things. Like the + at the beginning and dollar signs are the things I'm confused about.
Kjlax Also because I have converted the data to table. The @Cost in the formula is making reference to the column with Cost as the header
Hi Kjlax
Ignore the "+", I use it most times instead of "=" to precede my formula. they both achieve the same purpose.
The dollar sign is to ensure that L10 is referenced without moving to either L11 or M10 when you drag the formula to another cell. The essence is to lock the cell in the formula.