Re: An array excel formula to shorten an excel formula that contains many exponential
Quote from sarah81;773282Many thanks for your help
But If I am to replace the the number of years will I just need to change the 40 to the number of years wanted,
example
=SUMPRODUCT((1-0.035)^{0,1,2,3,4,5,6,7,8,9},CG22:DT22-C22:AP22+0.28*AR22:CE22/10^6*8.61)
will be replaced in which the portion will beCOLUMN(INDEX(1:1,1):INDEX(1:1,9))
Also do I need to fix the (1:1) in the index formula, as it doesnt seem to be working when I use the formula for 9 years
Example
COLUMN(INDEX($1:$1,1):INDEX($1:$1,9))