IFERROR not working on #SPILL!

[DashboardNovice]

Why doesn't IFERROR work on the #SPILL! error? Is there another solution?

It's seems that Excel doesn't recognize #SPILL!, for example if I try ISERROR() it returns FALSE. I even tested =IF(A1="#SPILL!","Spill error present","") and it returned 0.

 

[vletm]

The solution is to make sure that there are enough empty cells for results.
More solutions ...

How to correct a #SPILL! error - Microsoft Support

How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).

support.microsoft.com

 

[DashboardNovice]

In this case, because of what I'm doing, I'm ok with the SPILL error occurring when it does. It's just that I want to do error handling when I encounter it.

 

[p45cal]

Recognises it here:


after clearing the cell causing the SPILL error: