Average of an If Formula



Can anyone provide some insight on why I am unable to get an average on a column of IF formulas?

Here is the formula across the rows in the column: =IF(Status2 = "Not Started", "0%", IF(Status2 = "In Progress", "50%", IF(Status2 = "Completed", "100%")))

I am getting a #DIVIDE BY ZERO error when I use the AVG formula on 10 rows.

When I try to sum the rows and divide by 10, I get 0.000 as the result.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!