Nested if

[shes_ohwsome]

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

Hi All,

Need your help with this in excel Also like to put limit , if any of the result is >100 , result should be 100.

 

[Peter_SSs]

Duplicate to HELP: Nested if

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.