Forum Discussion
Franc_Odoshe
Apr 03, 2020Copper Contributor
Min Max Formula
Kindly see attached and assist.
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 should return UNDERSTOCK and by how less.
Scenario 3 -
If cell G3 is in between cell D3 and E3 then cell H3 should return WITHIN RANGE.
One formula to capture cell H3....any ideas ladies and gentlemen???
Patrick2788 AWESOME....THIS IS MORE LIKE IT. YOU BE BLESSED ABUNDAnTLY.
- Patrick2788Silver Contributor
=IF(G3>D3,"OVERSTOCK: "&G3-D3,IF(G3<E3,"UNDERSTOCK: "&E3-G3,"WITHIN RANGE"))
- Franc_OdosheCopper Contributor
Patrick2788 AWESOME....THIS IS MORE LIKE IT. YOU BE BLESSED ABUNDAnTLY.