Compound Multiplication Problem

[UDcc123]

My brain's gone blank for some reason. Say I have $100 in cell A1. And then I have -10% in cells A2, A3, A4, and A5. I want to know what happens if I take 10% off the $100 ($90)...and 10% off of that ($81), and so forth so I end up with $65.61 after taking four 10%s off.

I can keep a running total in column B, but I was hoping to do it in one cell with one formula. I can't say: A1 * (1+SUM(A2:A5)) because that returns $60 instead of $65.61. I'm drawing a blank on how to do this in excel.

Thanks

$100
-10% $90
-10% $81
-10% $73
-10% $65.61

 

[mikerickson]

Duplicate Post
https://www.mrexcel.com/forum/excel-questions/1090720-dumb-easy-multiplication-question.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
You posted your original thread to the correct board