Forum Discussion
Franc_Odoshe
Apr 03, 2020Copper Contributor
Min Max Formula
Kindly see attached and assist. exceltv Scenario 1 - If cell G3> cell D3 then cell H3 should return OVERSTOCK and by how many more. Scenario 2 - If cell G3 < cell E3 then cell H3 shoul...
- Apr 03, 2020
Patrick2788 AWESOME....THIS IS MORE LIKE IT. YOU BE BLESSED ABUNDAnTLY.
Patrick2788
Silver Contributor
=IF(G3>D3,"OVERSTOCK: "&G3-D3,IF(G3<E3,"UNDERSTOCK: "&E3-G3,"WITHIN RANGE"))
Franc_Odoshe
Apr 03, 2020Copper Contributor
Patrick2788 AWESOME....THIS IS MORE LIKE IT. YOU BE BLESSED ABUNDAnTLY.