Forum Discussion
Formula Spilling Over
Hello, I've encountered an issue when entering formula into a cell that I haven't encountered before. After entering the formula it spills over into the following cells and I'm not sure how to fix ...
Better to change the formula forcing it to return scalar value, not an array. Not optimal way, but you may try to place @ in from of it
=IF(...)
to
=@IF(...)
I tried adding the @ in front and that actually helped and now I don't get that issue. Thank you very much for your help.