Forum Discussion
#OVERLOOP!
Hello, I try to make a formula in which is checked if four cells of a previous tab is empty. If so it needs to leave the cell empty. If not than the cell needs to have the value of the average. I d...
Unfortunately this didn't work.
So the problem is:
In another tab I calculate the average. If all fields are empty I want to use an If function to leave the cell empty. Now I see the #OVERLOOP! message and I can't find the problem why.
Excel is telling you that your formula will produce multiple results but there are not enough neighboring cells to display them.
Example. Excel needs C1:C3 to display the results of the IF. C2:C3 are occupied so the result is a #SPILL! error.