software

I am trying to store a formula in a cell and evaluate when data is input.
Example; Credit Card Bal that lowers the available amount as it items are
posted. I want to store in many more cells.

F G
($9,000.05)$999.95
($7,697.25)$1,302.80
($7,627.80)$69.45
($7,252.80)$375.00
($6,920.82)$331.98
($5,880.82)$1,040.00
($4,368.40)$1,512.42
($2,910.45)$1,457.95
($2,655.30)$255.15
($175.80)$2,479.50
($75.80)$100.00
($72.80)$3.00
($71.80)$1.00

formula is : =SUM(F7,G8) in each cell.
Hi, try:

=IF(F8gt;0,SUM(F7,G8),quot;quot;)Hopes this helps!
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=493527Can I save the formula in the cell? I don't want it to show any figues until
G colum is input.

quot;CLRquot; wrote:

gt; The way your data is laid out...........it looks to me like in cell F8 you
gt; would want this formula:
gt;
gt; =F7-G8
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;ggantquot; wrote:
gt;
gt; gt; I am trying to store a formula in a cell and evaluate when data is input.
gt; gt; Example; Credit Card Bal that lowers the available amount as it items are
gt; gt; posted. I want to store in many more cells.
gt; gt;
gt; gt; F G
gt; gt; ($9,000.05)$999.95
gt; gt; ($7,697.25)$1,302.80
gt; gt; ($7,627.80)$69.45
gt; gt; ($7,252.80)$375.00
gt; gt; ($6,920.82)$331.98
gt; gt; ($5,880.82)$1,040.00
gt; gt; ($4,368.40)$1,512.42
gt; gt; ($2,910.45)$1,457.95
gt; gt; ($2,655.30)$255.15
gt; gt; ($175.80)$2,479.50
gt; gt; ($75.80)$100.00
gt; gt; ($72.80)$3.00
gt; gt; ($71.80)$1.00
gt; gt;
gt; gt; formula is : =SUM(F7,G8) in each cell.
gt; gt;

Use this in F8 instead.........

=IF(G8=quot;quot;,quot;quot;,F7-G8)

Vaya con Dios,
Chuck, CABGx3
quot;ggantquot; wrote:

gt; Can I save the formula in the cell? I don't want it to show any figues until
gt; G colum is input.
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; The way your data is laid out...........it looks to me like in cell F8 you
gt; gt; would want this formula:
gt; gt;
gt; gt; =F7-G8
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;ggantquot; wrote:
gt; gt;
gt; gt; gt; I am trying to store a formula in a cell and evaluate when data is input.
gt; gt; gt; Example; Credit Card Bal that lowers the available amount as it items are
gt; gt; gt; posted. I want to store in many more cells.
gt; gt; gt;
gt; gt; gt; F G
gt; gt; gt; ($9,000.05)$999.95
gt; gt; gt; ($7,697.25)$1,302.80
gt; gt; gt; ($7,627.80)$69.45
gt; gt; gt; ($7,252.80)$375.00
gt; gt; gt; ($6,920.82)$331.98
gt; gt; gt; ($5,880.82)$1,040.00
gt; gt; gt; ($4,368.40)$1,512.42
gt; gt; gt; ($2,910.45)$1,457.95
gt; gt; gt; ($2,655.30)$255.15
gt; gt; gt; ($175.80)$2,479.50
gt; gt; gt; ($75.80)$100.00
gt; gt; gt; ($72.80)$3.00
gt; gt; gt; ($71.80)$1.00
gt; gt; gt;
gt; gt; gt; formula is : =SUM(F7,G8) in each cell.
gt; gt; gt;