Hello,
I think I'm needing some type of multiple if function, but am not sure. I am wanting to create one formula that will calculate the TARGET SKU QUANTITY (column K). I provided two examples below.
Here are the steps for the formula (USING ROW 3 AS EXAMPLE):
#1. B3 * 6 = INVENTORY UNIT...