Prev: Copy from another sheet but spreading the data out down the co
Next: May be a long-shot, but.....
From: sony654 on 4 Jul 2008 00:43
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
From: T. Valko on 4 Jul 2008 01:00
Try this:

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


--
Biff
Microsoft Excel MVP


"sony654" <sony654(a)discussions.microsoft.com> wrote in message
news:B7313BBB-0425-438E-96CA-57DAC419DBE8(a)microsoft.com...
> 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


From: sony654 on 4 Jul 2008 22:40
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" <sony654(a)discussions.microsoft.com> wrote in message
> news:B7313BBB-0425-438E-96CA-57DAC419DBE8(a)microsoft.com...
> > 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
>
>
>
From: T. Valko on 5 Jul 2008 00:05
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"sony654" <sony654(a)discussions.microsoft.com> wrote in message
news:D233216E-9BD9-4DFE-AEC2-FB254FECA186(a)microsoft.com...
> 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" <sony654(a)discussions.microsoft.com> wrote in message
>> news:B7313BBB-0425-438E-96CA-57DAC419DBE8(a)microsoft.com...
>> > 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
>>
>>
>>


 | 
Pages: 1
Prev: Copy from another sheet but spreading the data out down the co
Next: May be a long-shot, but.....