Average & #DIV/0

Giganews Newsgroups
Subject: Average & #DIV/0
Posted by:  RayD (rcd_n…@hotmail.com)
Date: Tue, 14 Oct 2003

Hello everybody

When I try to apply the following formula I get the dreaded #DIV/0

=IF(average(E8:E372)=0,"",average(E8:E372))

Anyone care to take a shot at this?

Many thanks

Replies