Forum Discussion
#SPILL!-errors are driving me nuts.
Hello all. I'm pulling my hair out again over Excel returning a SPILL error for a perfectly normal function (No arrays etc.). What's going on here? =IFERROR((1-MIN(ABS($B8)/3,1))*B3+MIN(ABS($B8)/3...
If COLUMN(B3)-COLUMN($B3)+1-SIGN($B8) evaluates to 0, INDEX will return the entire row $B3:$F3, causing your formula to return 3 cells.