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

WH Stocks	Recommended	Stocklogic	Expected output
100	50	10	Recommended
100	110	50	Stocklogic
100	10	50	Stocklogic
0	100	50	0

<tbody>
</tbody>

Conditions: 1. If Stocklogic is higher than Recommended Get Stocklogic value 2. If Recommeded is higher than stocklogic GET Recommended value 3. If Recommended is higher than WH stocks get Stocklogic value 4. If WH Stocks is 0 Final should be 0 <tbody> </tbody> <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[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.