formatting for formulas
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!
|