Clearing the "DIV/0!" message.

  • Thread starter Thread starter GBL
  • Start date Start date
G

GBL

Hi Guys (and Gals):
I have the function AVERAGE(A1,C1,E1,G1) working fine; except that it
produces the message "DIV/0!" when there are no entries in A1, C1, E1, and
G1. Some time ago I noticed a tip on how to eliminate this "DIV/0!" message
(hope I've got the correct newsgroup).
Anyone recall the tip??
 
GBL, here is one way

=IF(ISERROR(AVERAGE(A1,C1,E1,G1)),"",AVERAGE(A1,C1,E1,G1))


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
This will help =IF(ISERROR(AVERAGE(A1,C1,E1,G1)),"",AVERAGE(A1,C1,E1,G1))
Bernard
 
Hi Paul:
Thanks for the valid reply!! While waiting for a reply I found the
reference. Was in John Walkenbach's book (page 505) - which was the same
logic as yours. Thanks again!!!
 
Back
Top