Forum Discussion
Trying To Remove the #DIV/0! Error
Greetings, I'm trying to get rid of the #DIV/0! message for the following: =(G26+J26)/(F26+I26). This formula is for my basketball player's SHOOTING PERCENTAGE for the game. Please take a look at my...
Hello,
wow, you really didn't need to upload all the sheets in the workbook. It is more confusing than helpful, because you don't say where your data is and where you want to see the result.
So, without looking at the workbook, if you want to avoid the #Div/0 error, don't divide if the divisor is zero.
=(G26+J26)/(F26+I26)
If (F26+I26) results in zero, you will get the error, so only perform the division when that sum is greater than zero, otherwise return a blank.
=if(F26+I26>0,(G26+J26)/(F26+I26),"")
With that, the error message in the 3D Average cell in S52 will also go away.