Thread: #div/0

I have tried a few formulas to make #DIV/0 show as either 0 or blank if there is nothing entered in C173:AG173 but have not come up with it. As always help is geatly appreciated. Thanks

=AVERAGE(C173:AG173)

=IF(COUNT(C173:AG173) = 0, 0, AVERAGE(C173:AG173))

Thanks very much!!!!

Hi,
Please remember the forum rules and the requirement to wrap functions and code in code tags.

Just use

=IF(ISERROR(AVERAGE(C173:AG173)),0,AVERAGE(C173:AG173))

Rgds

You're very welcome.