M
Mark
Is it possible to return a value to a certain default value after it has
been changed and the worksheet has been saved? That is when worksheet
opened, it returns to a given default.
In the below example, using the Present Value of an Annuity, I want Type 1
to revert to Type 0 no matter what is saved. This will save me the erroneous
results when I forget to change it back. However, I want the rest of the
data to remain as saved.
Mark
Present Value of an Annuity
Type 1
Periods per yr 1
Rate 0.065
Nper 10
Period pmt 500
FV
PV $3,828.05
been changed and the worksheet has been saved? That is when worksheet
opened, it returns to a given default.
In the below example, using the Present Value of an Annuity, I want Type 1
to revert to Type 0 no matter what is saved. This will save me the erroneous
results when I forget to change it back. However, I want the rest of the
data to remain as saved.
Mark
Present Value of an Annuity
Type 1
Periods per yr 1
Rate 0.065
Nper 10
Period pmt 500
FV
PV $3,828.05