Thanks JulieD,
Let me better explain my problem.
I have a formula.
=NPV(F75,I73:S73)+G73
The range in this formula I73:S73 covers 11 cells. The 11 represents an 11
Year lease. I do not want the user to adjust the range every time we
calculate a new lease. (Some leases are for 2 years some are for 10 years).
How can I modify this formula so that the ending cell in the range will be
based upon the number of Lease Years.
Example: IF this were a 10 year lease I would want the formula to
dynamically adjust itself accounting for only the values in the cell range
I73:R73..
Thanks Again
"JulieD" wrote:
Not sure i understand the question - what do you want to know?
do you want to know how to develop a function that uses a range - if so, any
particular function
do you want to know how to create a dynamic range - if so, check out dynamic
ranges at www.contextures.com/tiptech.html
Cheers
JulieD
"ACase" wrote in message
...
Hello,
I need to develop a function which uses a range. The range is dynamic
based
upon a Lease Term.
Example: I have a 5 year lease - The range will encompase 5 cells
(A1:E1).
I will always know the starting Cell.
Any help would be much appreciated.
thanks
ACase