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 GOAL (formula shown in F3)
#2. if MAX UNITS SOLD IN A MONTH is greater than (INVENTORY UNIT GOAL / 2), then (INVENTORY UNIT GOAL * 2). If MAX UNITS SOLD IN A MONTH is less than (INVENTORY UNIT GOAL / 2), then INVENTORY UNIT GOAL.
#3. The end result is shown in K3
I am horrible at trying to explain this... I hope the example below helps my question make sense.
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]
[TD="bgcolor: #E5E5E5, align: center"]SKU Numbers
(example for forum)[/TD]
[TD="bgcolor: #3A5A63, align: center"]Average Monthly Units Sold[/TD]
[TD="bgcolor: #3A5A63, align: center"]Highest Amount of Units Sold in a Month[/TD]
[TD="bgcolor: #3A5A63, align: center"]Total Units Sold[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E2F1ED, align: center"]INVENTORY UNIT GOAL[/TD]
[TD="bgcolor: #E2F1ED, align: center"] (INVENTORY UNIT GOAL) DIVIDED BY 2[/TD]
[TD="bgcolor: #E2F1ED, align: center"]MAX UNITS SOLD IN A MONTH[/TD]
[TD="bgcolor: #E2F1ED, align: center"]IS MAX UNITS GREATER THAN (INVENTORY GOAL X 50%?)?[/TD]
[TD="bgcolor: #E2F1ED, align: center"](INVENTORY GOAL) X 2[/TD]
[TD="bgcolor: #FF0000, align: center"]TARGET SKU QTY[/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: #DDF0F2"]sku 1[/TD]
[TD="align: right"]2.08[/TD]
[TD="align: right"]12[/TD]
[TD="bgcolor: #CEDDE1, align: right"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"]12.5[/TD]
[TD="align: right"]6.25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #DDF0F2"]sku 2[/TD]
[TD="align: right"]4.92[/TD]
[TD="align: right"]10[/TD]
[TD="bgcolor: #CEDDE1, align: right"]59[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29.5[/TD]
[TD="align: right"]14.75[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]29.5[/TD]
</tbody>
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 GOAL (formula shown in F3)
#2. if MAX UNITS SOLD IN A MONTH is greater than (INVENTORY UNIT GOAL / 2), then (INVENTORY UNIT GOAL * 2). If MAX UNITS SOLD IN A MONTH is less than (INVENTORY UNIT GOAL / 2), then INVENTORY UNIT GOAL.
#3. The end result is shown in K3
I am horrible at trying to explain this... I hope the example below helps my question make sense.
A | B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|---|
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]
[TD="bgcolor: #E5E5E5, align: center"]SKU Numbers
(example for forum)[/TD]
[TD="bgcolor: #3A5A63, align: center"]Average Monthly Units Sold[/TD]
[TD="bgcolor: #3A5A63, align: center"]Highest Amount of Units Sold in a Month[/TD]
[TD="bgcolor: #3A5A63, align: center"]Total Units Sold[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E2F1ED, align: center"]INVENTORY UNIT GOAL[/TD]
[TD="bgcolor: #E2F1ED, align: center"] (INVENTORY UNIT GOAL) DIVIDED BY 2[/TD]
[TD="bgcolor: #E2F1ED, align: center"]MAX UNITS SOLD IN A MONTH[/TD]
[TD="bgcolor: #E2F1ED, align: center"]IS MAX UNITS GREATER THAN (INVENTORY GOAL X 50%?)?[/TD]
[TD="bgcolor: #E2F1ED, align: center"](INVENTORY GOAL) X 2[/TD]
[TD="bgcolor: #FF0000, align: center"]TARGET SKU QTY[/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: #DDF0F2"]sku 1[/TD]
[TD="align: right"]2.08[/TD]
[TD="align: right"]12[/TD]
[TD="bgcolor: #CEDDE1, align: right"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"]12.5[/TD]
[TD="align: right"]6.25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]TRUE[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #DDF0F2"]sku 2[/TD]
[TD="align: right"]4.92[/TD]
[TD="align: right"]10[/TD]
[TD="bgcolor: #CEDDE1, align: right"]59[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29.5[/TD]
[TD="align: right"]14.75[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]FALSE[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]29.5[/TD]
</tbody>
2016 Sales by Sku