Multiple if function...

[andoano]

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.

	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​

 

[FDibbins]

Try this...
=IF(H3>G3,F3*2,F3)

 

[andoano]

That actually works perfectly and gives me the end result I'm looking for. But what I'm trying to do is, condense Column F, G, H, I, J, and K all into one formula that goes into one cell. So all you would see is TARGET SKU QTY (Currently in K3) in F3

 

[jtakw]

Hi,

I think this is what you want, I wrapped it with ROUND to match with your sample result:

Excel 2010
	A	B	C	D	E	F	G
1
2	SKU Numbers	Average Monthly Units Sold	Highest Amount of Units Sold in a Month	Total Units Sold		TARGET SKU QTY	Slightly shorter formula
3	sku 1	2.08	12	25		25	25
4	sku 2	4.92	10	59		29.5	29.5
Sheet1

Cell Formulas
Range	Formula
F3	=ROUND(IF(C3>B3*6/2,B3*6*2,B3*6),1)
G3	=ROUND(IF(C3>B3*3,B3*12,B3*6),1)

 

[FDibbins]

Or maybe just this...
=IF(C3>B3*3,B3*12,B3*6)

 

[jtakw]

I wrapped it with ROUND to match with your sample result:

That the same as G3 formula in post 4.

 

[FDibbins]

Pretty much, yes

I had not refreshed when I posted

 

[andoano]

That's it! I was overthinking this big time. That in combination with no real knowledge of excel made for a disaster. Thanks very much to the both of you. I will learn a few lessons from this.

 

[FDibbins]

Happy to help

 

[jtakw]

You're welcome.