| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP - Return value of the cell below the formula's answer | Excel Discussion (Misc queries) | |||
| Cell displays formula instead of the formula's result | Excel Worksheet Functions | |||
| Multiple format single cell that has formula's | Excel Discussion (Misc queries) | |||
| displaying a formula's answer into a separate cell | Excel Worksheet Functions | |||
| how do i copy a formula's result to another cell, without copying. | Excel Worksheet Functions | |||
Linear Mode
