formatting for formulas

[Guest]

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!

 

[RagDyer]

Try this:

=(A1<=B1)*B1-A1

 

[Peo Sjoblom]

=MAX(0,B1-A1)


--


Regards,


Peo Sjoblom

 

[Guest]

Thanks. in playing around with it a bit I realized that I need the "roundup"
function. Thanks!

 

[Peo Sjoblom]

Why?


--


Regards,


Peo Sjoblom

Thanks. in playing around with it a bit I realized that I need the
"roundup"
function. Thanks!