Forum Discussion
gillianoleary
Jun 30, 2020Copper Contributor
Spill Error with named ranges on a table
Hey, I have a table and when i enter =Hours*Rate it returns a #SPILL! but if i enter the same outside the table i get the result, i know i can enter =[@Hours]*[@Rate] in the table but i just wan...
PeterBartholomew1
Jul 03, 2020Silver Contributor
If I have understood your situation correctly,
= hours * rate
would only have worked in O2016 because of implicit intersection, which causes the formula to return a sequence of single-cell results. Trying to enter a multi-cell (CSE) array formula would always have failed. Now as the defaults have changed in MS365, you could achieve the previous result using
= @hours * @rate
Better, I believe, is to use the Table for input data, but then switching to dynamic arrays for calculation.
Don Bleeker
Mar 16, 2023Copper Contributor
In regards to :
Better, I believe, is to use the Table for input data, but then switching to dynamic arrays for calculation. Iam using two tables and try to paste data from one to other, get spill. Any help
would be appreciated.? Thanks in advance Don
Better, I believe, is to use the Table for input data, but then switching to dynamic arrays for calculation. Iam using two tables and try to paste data from one to other, get spill. Any help
would be appreciated.? Thanks in advance Don