=MAX(0,B1-A1)


--


Regards,


Peo Sjoblom



"glenn" wrote in message
...
I'm trying to format a cell in excel for inventory ordering. Cell "A" is
the
current level on hand (say 3 units for example). Cell "B" is the par
(assume
that the par is 4). I need Cell "C" to automatically populate "1" (as in
order 1 unit...)
so, if A is less than or equal to B I need it to automatically make up the
difference in C (for instant order sheets). Thanks!