How do I automatically start and stop a calc?

[Jim]

I'm using Excel 2000 as part of Office 2000 Professional.
I have several sheets that I use as a financial plan
template. In one sheet I run a calculation to determine
an account balance after a defined number of years.
Since this is a template and used for each client, the
data is always different, including the age of the client
or year the calculation begins.
My problem is, I need to be able to have the calculation
start at a certain age and stop at a certain age, without
me doing it manually. I use this calculation to create a
graph of the data.
Is there a way to just enter the variables like account
balance, contributions, rate of return and then tell it
to run from say age 45 to age 59 and not have to change
things for the next case?

Any help you can give is always welcome. Thanks, Jim

 

[IC]

Assuming age is in A1, put this in the target cell:

=IF(OR(A1<45,A1>59),"",your calculation here))

This will clear the cell unless the age is between 45 & 59.

Ian