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)
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
RgdsPlease Login or Register to view this content.
You're very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks