easy5 pts · first answer countsexceldynamic-arraysformula-errors

What #SPILL! means

A UNIQUE formula in E2 shows #SPILL!. Clicking it shows a dashed border over E2:E15, and E9 contains a note someone typed. What is the fix?

A.Change the formula so it starts from row 1 insteadB.Clear E9 so the results have room to spillC.Turn calculation to Manual and then back to AutomaticD.Convert the formula result into text

Discussion 0

Join free to post in the discussion.

What #SPILL! means

Discussion 0

Related questions