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