I have a small spreadsheet that calculates the retail cost of items based on wholesale cost, plus markup, and adding in shipping cost, and then indicates with conditional formatting if the price has changed on item(s) in the list.
However, it references an absolute value for the shipping cost (based on a separate calculation) and applies that value to all items in the sheet.
My problem is, if we only receive SOME items, or if the shipping costs change (based on a different size order, for example), if I were to apply the costs, the shipping cost will change the final cost of ALL items in the list, not just the ones we received.
Is there a simple way to tell Excel to only apply the value of the shipping cost to SOME rows, perhaps even something as simple as checking another cell that an item was received or not?
Attaching an example sheet. In the worksheet, I would first calculate shipping by entering how many pieces (D2) and the shipping cost of the order (C2) which formula results display in (E2).
Then, I would adjust the costs in column F based off our invoice, it will calculate across the rows, displaying the new price in column D. The current price is in column B, and column C uses conditional formatting to highlight if the price has changed since the last invoice based on comparing B to D (row 9 shows an example of this).
As it exists, the sheet uses the shipping value from E2 and applies it to every row. But, if we get a new order and only get Items A, B, and F for example, and the shipping costs change drastically - how can I have the new shipping cost apply to ONLY those items?
File attached I hope it comes through
Blank Example.xlsx

I was thinking either a check box or even just indicating a quantity of X were received based on the row(s) in question as a way, some sort of "if Row 3, cell A has a quantity of 1 (indicating item received) then apply the absolute value of E2 to that row...."
Thanks!!!