2 Formula's in one cell
 

In my total cell I have one formula that subracts out of my inventory when i
add a number to my out cell example: in cell K i have =d9-i9, i would like in
the same cell i9+j9 when i loose inventory cell k subtracts and when i gain
inventory cell k adds...

please help

2 Formula's in one cell
 

So you want to use differenet formulas depending on whether you gain or loose
inventory. In that case use an if function

=if(GainInventory, d9-i9, i9+j9)

You did not supply an logic as to how you determine if you have gained or
lost inventory so I lease that for you to fill in.
--
HTH...

Jim Thomlinson


"Dave" wrote:

In my total cell I have one formula that subracts out of my inventory when i
add a number to my out cell example: in cell K i have =d9-i9, i would like in
the same cell i9+j9 when i loose inventory cell k subtracts and when i gain
inventory cell k adds...

please help