M
murph
I have turned on the iterations (set to 1) for circular values.
here is the scenario:
I want to keep a runnng total of $$ used
I have a cummulative total cell (A1), and a used today (A2)
the formula in A1 is =A1+A2
this works well in the fact that it keeps the running total in A1. it
updates the total correctly when I put in a new value in A2.
The problem is that when any other cell value in the spreadsheet changes, it
recalucaltes A1 again and adds the value in A2 to the total again.
It also does this same recalculation on saving or opening the spreadsheet
which I also need to turn off somehow.
I would prefer not to have users to do a manual calculation if possible
here is the scenario:
I want to keep a runnng total of $$ used
I have a cummulative total cell (A1), and a used today (A2)
the formula in A1 is =A1+A2
this works well in the fact that it keeps the running total in A1. it
updates the total correctly when I put in a new value in A2.
The problem is that when any other cell value in the spreadsheet changes, it
recalucaltes A1 again and adds the value in A2 to the total again.
It also does this same recalculation on saving or opening the spreadsheet
which I also need to turn off somehow.
I would prefer not to have users to do a manual calculation if possible