I had an excel formula that contained nine exponentials, the formula was initially complicated but it was shortened with an array of 9 years.
this is the old formula. they were two formulas
I have now entered several columns in the excel spreadsheet to change it from 9yrs to 40 years, so I need an array of 40 years and It seems a bit complicated to enter the bracket (1,2,3,4 ..............40)
this the new formula with the added columns but not with the 40 arrays added.
Can someone please advise how I can change the number of years from 9 to 40 without entering the (1,2 .... till 40)
I have posted this in a previous thread as a reply, am trying to link it but am having issues doing that, so apologies for the inconvenience