Formula needed to solve the following patternlist in excel - Stack Overflow

admin管理员组

文章数量:1277336

What formula could i put starting with cell A2 that would create the following computational list of numbers all the way down. I want to start with a number then in cell A1 and then in the cell below it (A2) have it write the same value as above, then in cell A3 take the value in cell A2 and multiple it by 1.5, then in cell A4 have the same value as in cell A3 and so on ..... ?
Your help is appreciated. Thanks.

What formula could i put starting with cell A2 that would create the following computational list of numbers all the way down. I want to start with a number then in cell A1 and then in the cell below it (A2) have it write the same value as above, then in cell A3 take the value in cell A2 and multiple it by 1.5, then in cell A4 have the same value as in cell A3 and so on ..... ?
Your help is appreciated. Thanks.

• excel
• formula
• computation

Share Improve this question Follow asked Feb 24 at 5:06 TG33TG33 1333 bronze badges 0

Add a comment  | 

4 Answers 4

Sorted by: Reset to default 2

You may try nested SCAN() function.

=SCAN(A1,SCAN(0,SEQUENCE(10),LAMBDA(a,b,IF(ISEVEN(b),1.5,1))),LAMBDA(x,y,x*y))

For older Excel versions =IF(A2<>A1,A2,A2*1.5) dragged down could do the trick, but there is a drawback - formula links to 2 cells above, so it can't start in A2.

Result:

If you are willing to type in the first two values manually then the following formula in A3 should work:

=A1*1.5

In 365 you can use:

A1: =SCAN(100/1.5,SEQUENCE(10,,0,0.5),LAMBDA(a,b,IF(b=INT(b), a*1.5,a)))

The first argument in the SEQUENCE function is the number of rows you want in your result.

本文标签： Formula needed to solve the following patternlist in excelStack Overflow