I have a simple question that I cannot find an answer to (tried searching forums.) I would like to take a currecny value in one cell and add a currency value from another cell to itslef.
Example:
cell A1 = $5.00
cell A2 = $3.00
new value for cell A1 = $8.00
Of course I realize that there is a potential of an infinite loop here but I was hoping that this formula would only run when cell A2 is changed. I am doing data entry to a chart of accounts and I am tired of switching to my calculator then back to excel.
Would variables work better? I can't figure out how to use them
I can't get the variable in the cell.
Thanks.
Bookmarks