#value! Error
 

The below function returns a #value! error. I would like the below function
to return "-" only if every cell in the range is empty. Help is appreciated
writing this.

=IF(B56:af56="","-",AVERAGE(B56:AF56))


--
Sony Luvy

#value! Error
 

Try this:

=IF(COUNT(B56:AF56),AVERAGE(B56:AF56),"-")


--
Biff
Microsoft Excel MVP


"sony654" wrote in message
...
The below function returns a #value! error. I would like the below
function
to return "-" only if every cell in the range is empty. Help is
appreciated
writing this.

=IF(B56:af56="","-",AVERAGE(B56:AF56))


--
Sony Luvy

#value! Error
 

Biff, Thanks again, this worked great - Tom
--
Sony Luvy


"T. Valko" wrote:

Try this:

=IF(COUNT(B56:AF56),AVERAGE(B56:AF56),"-")


--
Biff
Microsoft Excel MVP


"sony654" wrote in message
...
The below function returns a #value! error. I would like the below
function
to return "-" only if every cell in the range is empty. Help is
appreciated
writing this.

=IF(B56:af56="","-",AVERAGE(B56:AF56))


--
Sony Luvy

#value! Error
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"sony654" wrote in message
...
Biff, Thanks again, this worked great - Tom
--
Sony Luvy


"T. Valko" wrote:

Try this:

=IF(COUNT(B56:AF56),AVERAGE(B56:AF56),"-")


--
Biff
Microsoft Excel MVP


"sony654" wrote in message
...
The below function returns a #value! error. I would like the below
function
to return "-" only if every cell in the range is empty. Help is
appreciated
writing this.

=IF(B56:af56="","-",AVERAGE(B56:AF56))


--
Sony Luvy