Nested if

[shes_ohwsome]

Hi Everyone,

I need help about nested if. I have set of conditions that needs to be followed, unfortunately I dont know how to do it in Excel. Please help

[TABLE="width: 500"]
<tbody>[TR]
[TD]WH Stocks[/TD]
[TD]Recommended[/TD]
[TD]Stocklogic[/TD]
[TD]Expected output[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]50[/TD]
[TD]10[/TD]
[TD]Recommended[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]110[/TD]
[TD]50[/TD]
[TD]Stocklogic[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]10[/TD]
[TD]50[/TD]
[TD]Stocklogic[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 418"]
<tbody>[TR]
[TD="width: 418"]Conditions:
[TABLE="width: 418"]
<tbody>[TR]
[TD="width: 418"][TABLE="width: 665"]
<tbody>[TR]
[TD="width: 665"]1. If Stocklogic is higher than Recommended Get Stocklogic value
[TABLE="width: 665"]
<tbody>[TR]
[TD="width: 665"]2. If Recommeded is higher than stocklogic GET Recommended value
[TABLE="width: 665"]
<tbody>[TR]
[TD]3. If Recommended is higher than WH stocks get Stocklogic value[/TD]
[/TR]
[TR]
[TD]4. If WH Stocks is 0 Final should be 0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

Only the condition is missing if Recommended = Stocklogic

Try this

Book1
	A	B	C	D
1	WH Stocks	Recommended	Stocklogic	Expected output
2	100	50	10	Recommended
3	100	110	50	Stocklogic
4	100	10	50	Stocklogic
5	0	100	50	0
Hoja5

Cell Formulas
Range	Formula
D2	=IF(A2=0,0,IF(B2>A2,$C$1,IF(B2>C2,$B$1,$C$1)))

 

[Fergus]

or try this =IF(A2=0,0,IF(OR(C2>B2,B2>A2),C2,IF(B2>C2,B2,)))

But what answer do you want if there is equality between any of them?

 

[shes_ohwsome]

or try this =IF(A2=0,0,IF(OR(C2>B2,B2>A2),C2,IF(B2>C2,B2,)))

But what answer do you want if there is equality between any of them?

Here is the updated:

WH Stocks	Recommended	Stocklogic	Expected output
100	50	10	Recommended
100	110	50	Stocklogic
100	10	50	Stocklogic
0	100	50	0
100	10	10	Stocklogic or Recommended
10	10	10	Stocklogic -2
10	10	4	Stocklogic

Also like to put limit , if any of the result is >100 , result should be 100.