Hello, this is my first post and I apologize if I break any rules.

I have a long formula meant to do a progressive calculation based on numbers input from another sheet. It will continue to grow as I develop the calculation sheet. Is there some way for me to shorten the formula while maintaining the ability to calculate it. The formula is as follows:

=(1-(1-(D13/100))*(1-(D14/100))*(1-(D15/100))*(1-(D16/100))*(1-(D17/100))*(1-(D18/100))*(1-(D19/100))*(1-(D20/100))...

It will continue till at least D800. My workbook has gone from about 350Kb to 5000Kb which is too large. I tried =(1-(1-(D13:D800/100)) but that does not work. I'm sure I'm missing something easy here but I cant quite get it.

Thanks for any help,
Pecos