Ignoring N/A

[cynster76]

How would I ignore the N/As in the below formula?

Thanks.

=((160.5/D3)*1/3)+((80.5/G3)*1/3)+((15.5%/J3)*1/3)

 

[Rhino373]

Just a thought, I think HotPeppers solution will error when one of those variables (cells) is zero because it is a number but it will provide a #DIV error.

 

[Scott Huish]

My formula will not generate a #DIV/0!. That has been taken into account.