Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |