Min Max Formula

[Franc_Odoshe]

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 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???

[#2]

@Franc_Odoshe 

=IF(G3>D3,"OVERSTOCK: "&G3-D3,IF(G3<E3,"UNDERSTOCK: "&E3-G3,"WITHIN RANGE"))

[#3 · Accepted solution]

@Patrick2788 AWESOME....THIS IS MORE LIKE IT. YOU BE BLESSED ABUNDAnTLY.