Repeated Multiplication formula for Excel

0 votes
I'm trying to figure out how to get Excel to add another 3 to the formula after each subsequent computation.  Basically, I have a column with numbers in A: 10; 20; 30; 40 ...

And what I'm looking for is in B1 = (10 mult 3) = 30; in B2 = (20 mult 3 mult 3) = 180; in B3 = (30 mult 3 mult 3 mult 3) = 810 ...
Oct 7, 2022 in Others by Kithuzzz
 • 38,010 points • 678 views

1 answer to this question.

0 votes

Fun little problem using some basic maths:

=A1*3^ROW(A1)

enter image description here

answered Oct 8, 2022 by narikkadan
 • 63,420 points

Related Questions In Others

0 votes
1 answer

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
 • 63,420 points • 1,150 views
0 votes
1 answer

In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

answered Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 524 views
0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

answered Nov 26, 2022 in Others by narikkadan
 • 63,420 points • 1,644 views
0 votes
1 answer

Hiding the formula bar in Excel for a specific file

No, you cannot. Unfortunately, altering the CustomUI file ...READ MORE

answered Dec 17, 2022 in Others by narikkadan
 • 63,420 points • 428 views
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
 • 63,420 points • 561 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
 • 63,420 points • 416 views
0 votes
1 answer

Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
 • 63,420 points • 604 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
 • 63,420 points • 622 views
0 votes
1 answer

Excel formula for Euclidean distance

Euclidean Norm of a vector of size ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
 • 63,420 points • 1,249 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
 • 63,420 points • 976 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.