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,000 points • 1,022 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,600 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,600 points • 1,522 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,600 points • 928 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,600 points • 2,724 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,600 points • 721 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,600 points • 787 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,600 points • 851 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,600 points • 1,065 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,600 points • 995 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,600 points • 1,693 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,600 points • 1,208 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.