Forum Discussion

Malcolm Campbell's avatar
Malcolm Campbell
Copper Contributor
Sep 18, 2018

Calculating averages (percents) within a date range. Answer come back #DIV/0.

Calculating average percent complete for construction activities. If the activities are not applicable I enter N/A. If all the activities are N/A, the average result comes back as #DIV/0? I would lik...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Sep 18, 2018

Hi Malcolm,

 

You can wrap the AVERAGE function with the IFERROR function like the below example:

=IFERROR(AVERAGE(B1:B3),0)

 

 

Hope that helps

Resources