Forum Discussion
MirohLoome
Oct 18, 2024Copper Contributor
Fixing a #SPILL! error
My formula sometimes results in a spill error, and I'm unsure why. I have the formula =LET(Num, N2, All, SEQUENCE(Num), Factors, FILTER(All, MOD(Num, All)=0), Factors) listing the factors of the numb...
- Oct 18, 2024
It looks like one of your cells has a character in it:
LEN is being used in R in the screen cap.
MirohLoome
Oct 18, 2024Copper Contributor
Thanks!
Patrick2788
Oct 18, 2024Silver Contributor
You're welcome!