|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 4th, 2008, 05:43 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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 
|
|
#2
July 4th, 2008, 06:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
|
|
#3
July 5th, 2008, 03:40 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
|
|
#4
July 5th, 2008, 05:05 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value! Error
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "sony654" wrote in message news  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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
