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!

Try this:

=(A1<=B1)*B1-A1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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!

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

"RagDyer" wrote:

Try this:

=(A1<=B1)*B1-A1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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!

Why?


--


Regards,


Peo Sjoblom


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

"RagDyer" wrote:

Try this:

=(A1<=B1)*B1-A1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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!

=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!