Store formula in Cell
 

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.

Store formula in Cell
 

Hi, try:

=IF(F80,SUM(F7,G8),"")


Hopes this helps!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493527

Store formula in Cell
 

Can I save the formula in the cell? I don't want it to show any figues until
G colum is input.

"CLR" wrote:

The way your data is laid out...........it looks to me like in cell F8 you
would want this formula:

=F7-G8

Vaya con Dios,
Chuck, CABGx3



"ggant" wrote:

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.

Store formula in Cell
 

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

=IF(G8="","",F7-G8)

Vaya con Dios,
Chuck, CABGx3



"ggant" wrote:

Can I save the formula in the cell? I don't want it to show any figues until
G colum is input.

"CLR" wrote:

The way your data is laid out...........it looks to me like in cell F8 you
would want this formula:

=F7-G8

Vaya con Dios,
Chuck, CABGx3



"ggant" wrote:

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.