I want to calculate x+x^2+x^3+x^4+.......+x^n or higher, where n=# of years. Also, I want to simply input the number of years and have the spreadsheet calculate the answer. for example, if n=8 years, then x+x^2+x^3+x^4+x^5+x^6+x^7+x^8 or if n=40 then x+x^2+x^3+x^4+x^5+x^6+x^7+x^8......x^40. I can use this, but it is cumbersome
=(1+B3)+POWER(1+B3,A8-1)+POWER(1+B3,A8-2)+POWER(1+B3,A8)
Is this possible?