Forum Discussion
BobNoyes_rnoyesphoto
Oct 19, 2023Copper Contributor
Need to figure out a formula to do the following
Hello, I am not very experienced in Excel but I am trying to make a spreadsheet that allows me to have the base cost of an item and multiply it by a set of specific % of markup to find the total price.
I have included a screenshot of what I have done so far but I can't figure out how to proceed. I'm sure it is an easy fix.
I am trying to take the LIST PRICE in Column B and apply the percentage in cells C4, D4, E4, and F4 to give me the total cost in the appropriate cell columns. I already have what I need to be done in row 4 (columns C-F) but I need it to have it work so that whenever I add an item LIST PRICE to column B for the specific Item (Column 1) it will automatically add the Percentages into the correct column. But I need this to do this from Rows 4-35. That way I do not have to enter the original formula that I am using in row 4 ( =(B4*C3) ) to each cell individually. I hope all this makes sense.
I appreciate any help!
=$B4*C$3
You can enter this formula in cell C4 and fill it across range C4:F35. This should work if i correctly understand what you want to do.
- OliverScheurichGold Contributor
=$B4*C$3
You can enter this formula in cell C4 and fill it across range C4:F35. This should work if i correctly understand what you want to do.
- BobNoyes_rnoyesphotoCopper Contributor
OliverScheurich
That worked Thanks!