Ok, so what is the Excell function that will solve my problem.
I am calculating a temporary life Insurance ( from Life Table) and need to
sum the column of a spreadsheet from 0 to n, n being the lenght (variable) of
the Temporary Life Insurance.
Any tips?
Ex.:product from p3 to p12 if n=10, p30 to22 if n=20, etc. Thing is i need
to be able tu put any value of n in the input table and that same n valu
affect the lenght of the items I need to multiply.
So far I am he
=B2*(1-PUISSANCE(Data!$B$4,lenght)*PRODUCT(Data!N4:@@@))
It is the part after the * that I am not ure how it should be coded.
With IF?
I donno
Thanks