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 number in cell N2, and a simple =SQRT(O3#) to show the square root of those factors in the next column. The factor-finding formula always works, but the square root formula results in the spill error when there are too many factors. Why is this and how do I fix it?
It looks like one of your cells has a character in it:
LEN is being used in R in the screen cap.
3 Replies
- Patrick2788Silver Contributor
It looks like one of your cells has a character in it:
LEN is being used in R in the screen cap.
- MirohLoomeCopper ContributorThanks!
- Patrick2788Silver ContributorYou're welcome!