CODEWITHSUNDEEP
excelformulacomputation
TG33
TG33

Reputation: 13

Formula needed to solve the following pattern/list in excel

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.

enter image description here

Upvotes: 0

Views: 54

Answers (4)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60379

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.

enter image description here

Upvotes: 0

cybernetic.nomad
cybernetic.nomad

Reputation: 6418

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

=A1*1.5

enter image description here

Upvotes: 1

user11222393
user11222393

Reputation: 5501

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:

enter image description here

Upvotes: 1

Harun24hr
Harun24hr

Reputation: 37050

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))

enter image description here

Upvotes: 2

Related Questions