This formula is used to identify a change in inventory quantity on hand that is over the maximum desired quantity stated in =IF(K2-'Min_ Max_ QOH'!H2>1,(K2-'Min_ Max_ QOH'!H2),0) where difference in the numbers entered in K2 is subtracted from the number in H2 in sheet Min_ Max_ QOH'!H2
How do I get the result as a positive or negative number ? Currently only providing positive results . If the desired Max quantity is 25 and I enter 0 it returns 0 when I actually have -25.
Thank you in advance for your support
How do I get the result as a positive or negative number ? Currently only providing positive results . If the desired Max quantity is 25 and I enter 0 it returns 0 when I actually have -25.
Thank you in advance for your support