Divide By Zero Error with Average
I'm trying to set up a formula that averages the scores for four columns, but doesn't bring up the Divide by Zero error if the scores haven't been entered yet (either leaves blank or puts a 0).
The Average formula works fine but I can't get the IFERROR part to work.
Current formula: =ROUND(AVG([LOR 1]1:[LOR 4]1), 1)
Help Article Resources
Check out the Formula Handbook template!