formatting for formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Thanks. in playing around with it a bit I realized that I need the "roundup"
function. Thanks!
 
Back
Top