Player Efficiency Rating

Hello,

Can someone please try to figure out the player efficiency rating on the Ratings! sheet? Also why am I getting #DIV/0! errors?

I have the stats and the EF in column V. I tried to do the formula in AB but it doesn't match.

The calculations are based on:

ER= Points + Rebounds + 2 (assists) + 2 (charges taken, steals, blocked shots)/
2 (missed shots) + missed FT's + 2 (turnovers) + 2 (fouls)

Adjusted ER for Increasing Performance Value of Rebounds and Assists

AER*= Points + 2 (Rebounds) + 3 (assists) + 2 (charges taken, steals, blocked shots)/
2 (missed shots) + missed FT's + 2 (turnovers) + 2 (fouls)


Player Efficiency Ratio
above 1.75 - Excellent
1.50-1.74 - Very Good
1.25-1.49 - Good
1.00-1.24 - Fair
below .99- Poor


Thank you very much for helping,
XJ

The .89 is the correct result that I am trying to achieve. Sorry for not being clear.

I figured it out thanks Richard for trying to help.