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
• 27,940 points
128 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
• 51,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
• 51,600 points
154 views
0 votes
1 answer
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
• 51,600 points
83 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
• 51,600 points
65 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
• 51,600 points
107 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
• 51,600 points
93 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
• 51,600 points
148 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
• 51,600 points
148 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
• 51,600 points
295 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
• 51,600 points
185 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