Increment a Number A1 by Increment B1

[ionelz]

Hi,
A1=23.2
B1=5

Result should be :
0
5
10
15
20
23.2
Thanks for help

 

[FormR]

Hi, you could try like this maybe..

Book1
	A	B	C
1	23.2		0
2	5		5
3			10
4			15
5			20
6			23.2
Sheet1

Cell Formulas
Range	Formula
C1:C6	C1	=LET(s,SEQUENCE(ROUNDUP(A1/A2,0)+1,,0,A2),IF(s>A1,A1,s))
Dynamic array formulas.

 

[ionelz]

Thank you

 

[ionelz]

If I change B1=4, it doesn't work

 

[Cubist]

Try:

Book1
	A	B	C
1	23.2	4	0
2			4
3			8
4			12
5			16
6			20
7			23.2
Sheet3

Cell Formulas
Range	Formula
C1:C7	C1	=UNIQUE(VSTACK(SEQUENCE(FLOOR.MATH(A1,B1)/B1+1,,0,B1),A1))
Dynamic array formulas.

 

[Phuoc]

Book1
	A	B	C
1	23.2	4	0
2	4		4
3			8
4			12
5			16
6			20
7			23.2
Sheet1

Cell Formulas
Range	Formula
B1	B1	=A2
C1:C7	C1	=LET(s,SEQUENCE(ROUNDUP(A1/A2,0)+1,,0,A2),IF(s-A1>0,A1,s))
Dynamic array formulas.

 

[FormR]

If I change B1=4, it doesn't work

What result do you expect when A2 B1=4?

Book1
	A	B	C
1	23.2	4	0
2			4
3			8
4			12
5			16
6			20
7			23.2
Sheet1

Cell Formulas
Range	Formula
C1:C7	C1	=LET(s,SEQUENCE(ROUNDUP(A1/B1,0)+1,,0,B1),IF(s>A1,A1,s))
Dynamic array formulas.

 

[ionelz]

I got in trouble with formulas.
All good but if A1 is Prime number then I get only 2 values, 0 and itself
So I want to keep formulas above BUT if A1 is Prime number then B1=2
So like if A1 is 11, results would be
0
2
4
6
8
10
1

 

[FormR]

I'm not following any of that really! Maybe the others will, or perhaps you can have another go at explaining it or give a few more examples of different inputs and their expected outputs.

 

[Scott Huish]

I agree. That new pattern doesn't match your original post. Why did your pattern end in 1, and not 11?
What does a prime number have to do with anything?
The only way that I would see that you would get 0 and the number in A1 is if was equal to the number in B1.
A1:5
B1:5

but this has nothing to do with prime numbers only that they are equal.