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?
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? Read More