Apr 03 2020 11:11 AM - edited Apr 03 2020 11:53 AM
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???
Apr 03 2020 12:24 PM
=IF(G3>D3,"OVERSTOCK: "&G3-D3,IF(G3<E3,"UNDERSTOCK: "&E3-G3,"WITHIN RANGE"))
Apr 03 2020 03:33 PM - edited Apr 03 2020 03:35 PM
Solution@Patrick2788 AWESOME....THIS IS MORE LIKE IT. YOU BE BLESSED ABUNDAnTLY.
Apr 03 2020 03:33 PM - edited Apr 03 2020 03:35 PM
Solution@Patrick2788 AWESOME....THIS IS MORE LIKE IT. YOU BE BLESSED ABUNDAnTLY.