software

I have a cell (E5) which represents a manually entered value quot;Inventoryquot; (say
10), in J5 the user enters 5 to reflect quot;Damaged Inventory Discardedquot;. I want
E5 to decrement by this J5 value to reflect the correct inventory value of 5.
How is this done/what function or for,ula.
Thanx - rc

Hi!

See this:

mcgimpsey.com/excel/accumulator.html

Biff

quot;1robc57quot; gt; wrote in message
...
gt;I have a cell (E5) which represents a manually entered value quot;Inventoryquot;
gt;(say
gt; 10), in J5 the user enters 5 to reflect quot;Damaged Inventory Discardedquot;. I
gt; want
gt; E5 to decrement by this J5 value to reflect the correct inventory value of
gt; 5.
gt; How is this done/what function or for,ula.
gt; Thanx - rc
Much thanx - just what I needed!

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; See this:
gt;
gt; mcgimpsey.com/excel/accumulator.html
gt;
gt; Biff
gt;
gt; quot;1robc57quot; gt; wrote in message
gt; ...
gt; gt;I have a cell (E5) which represents a manually entered value quot;Inventoryquot;
gt; gt;(say
gt; gt; 10), in J5 the user enters 5 to reflect quot;Damaged Inventory Discardedquot;. I
gt; gt; want
gt; gt; E5 to decrement by this J5 value to reflect the correct inventory value of
gt; gt; 5.
gt; gt; How is this done/what function or for,ula.
gt; gt; Thanx - rc
gt;
gt;
gt;