# Dumb easy multiplication question

#### UDcc123

##### Board Regular
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

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### UDcc123

##### Board Regular
Sorry...realize I posted this to the wrong board...not sure how to delete it, but I reposted this to the more used general excel board.

#### mikerickson

##### MrExcel MVP
If you have 100 in A1 and .1 in A2 and 4 in A3

=100*((1-A2)^A3)

will return the value after takind a 10% discount four times.

#### UDcc123

##### Board Regular
Thanks...I may have made my example too simplistic. What if the four % drops are all different random numbers?

#### mikerickson

##### MrExcel MVP

I think that A1*(RAND()^4) would return the same value (over time) as if you had four different cells and did a RAND() for each line

#### shg

##### MrExcel MVP
 A​ B​ 1​ \$ 100.00​ 2​ 15%​ 3​ 19%​ 4​ 20%​ 5​ 11%​ 6​ \$ 49.02​ A6: {=A1 * PRODUCT(1 - A2:A5)} 7​ \$ 49.02​ A7: =A1 * PRODUCT(INDEX(1 - A2:A5, 0))

Use the formula in A6 if you're comfortable with an array formula, otherwise the formula in A7.

#### LuisV805

##### New Member

Can you use this?

 A B 1 Percent Balance 2 100 3 10% 90 4 10% 81 5 10% 72.9 6 10% 65.61 7 10% 59.049

<colgroup><col width="78" span="3" style="width:59pt"> </colgroup><tbody>
</tbody>

Formula for B3:
=B2-(B2*A3)

Copy that down.

#### UDcc123

##### Board Regular
Thank you for the responses. The index formula roughly worked if I have all the same signs (like four -10%s)...but what if the four inputs are -10%, 5%, -8%, and -2%. I can do the running total method easily enough, but my post was to try and find an easier way in just one cell without the running formula.

In the example below, I'm trying to get the answer of \$85.20 that shows with the running total in B5...but when I use the product formula in cell B6, it returns \$84.88 instead of \$85.20.

A B
1 \$100
2 -10% \$90.00
3 5% \$94.50
4 -8% \$86.94
5 -2% \$85.20
6 \$84.88

#### Dave Patton

##### Well-known Member
try =FVSCHEDULE(A1,A2:A5)

Replies
2
Views
167
Replies
7
Views
43
Replies
4
Views
57
Replies
2
Views
103
Replies
1
Views
26