Oct 19 2023 01:05 PM
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!
Oct 19 2023 01:24 PM
Solution=$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.
Oct 19 2023 02:19 PM - edited Oct 19 2023 03:23 PM
Oct 19 2023 02:19 PM - edited Oct 19 2023 03:23 PM
@OliverScheurich
That worked Thanks!
Oct 19 2023 01:24 PM
Solution=$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.