tracking inventory
So, here's what I have.....
ColumnD = Qty. Shipped
ColumnE = Qty. Received
=IF(D:D0,C3-D3,0),(E:E0,C3+E3,0)
each () is giving the right answer but then I get a #Value error?
"Jacob Skaria" wrote:
missed the negative sign
=<current formula+IF(A10,A1,IF(B10,-B1,0))
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
Suppose
A1 = QTy Received
B1 = Qty shipped
In C1 (current inventory)
If you already have a formula
=<current formula+IF(A10,A1,IF(B10,B1,0))
If this post helps click Yes
---------------
Jacob Skaria
"Jackie" wrote:
if there's a # in the "Qty. Received" cell then I want it to add to the
"Current inventory" cell but if there's a # in the "Qty. Shipped" cell then I
want it to subtract it........how can i seperate these functions in 1 formula
so it will do either 1 or the other?
|