Forum Discussion

Copper Contributor

Dec 06, 2017

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...

Example Team Statistics Scorecard2.xlsx195 KB

excel

Tanya Denton

Steel Contributor

Dec 06, 2017

this may work, but couldn't test as i had no idea which columns to enter data in!!

=IFERROR(AVERAGE('GM 1 vs Central:GM 15 vs NatureCoast'!B28),0)