Store formula in Cell
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. |
All times are GMT +1. The time now is 04:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com