Forum Discussion
Excel 365 "If" function "Name" definition Spill error
Excel 2016 and prior I would use the Name of headings and refer to this when going to the "IF" function to give a result to the if EQ question. Using same process in 365 get "#SPILL" error. How do ...
ChristopherGeorger Spilling is a great feature of the "new" dynamic array functionality in MS365 and E2021. But, if something gets in the way and the output can't be spilled you get that error. Same thing when you try to use such a formula inside a structured table. What exactly are you trying to do? What is the formula that is causing the error?