Forum Discussion
breanna
Nov 03, 2025Copper Contributor
How to distribute the value of one cell evenly in a sequence for the value of another cell?
Hi there, I'm trying to evenly distribute numbers (not a set value) to help with crocheting - taking the math out for testers/creators right now I have the blue row working as a sequence, how...
m_tarler
Nov 03, 2025Bronze Contributor
try this
=LET(rows, 20, inc, 8,
incrows, ROUNDDOWN(rows/inc,0),
--(MOD(SEQUENCE(inc*incrows,,0),incrows)=0)
)so you can replace the 20 and 8 with cell references
line 2 calculates the inc/dec every number and takes only the integer portion
line 3 then creates a sequence of only the used range and checks when that is an even multiple of the inc/dec value and outputs 1 or 0 otherwise.
if you want a negatives then you need to multiply line 3 by SIGN()
=LET(rows, 20, inc, 8,
incrows, ROUNDDOWN(rows/inc,0),
SIGN(inc)*(MOD(SEQUENCE(inc*incrows,,0),incrows)=0)
)
- breannaNov 08, 2025Copper Contributor
Hi there, thank you for the help. This seems to only work for smaller numbers. If the increases are larger than the rows needed, it does something like this: