Forum Discussion

MarcAdank's avatar
MarcAdank
Copper Contributor
Feb 22, 2020

#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 did several attempts but failed until now.

=ALS('Invoer AK GS Nat'!D5:G5="";"";'Invoer AK GS Nat'!D5:G5/4) 

 

Hopefully someone can help me

 

excel
Formulas and Functions

3 Replies

    • MarcAdank's avatar
      MarcAdank
      Copper Contributor
      Feb 28, 2020

      Detlef_Lewin 

       

      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.

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Feb 28, 2020

        MarcAdank 

        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.

         

         

         

Resources