DashboardNovice
Member
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.
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.
Last edited: