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
|
|||
|
|||
#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
|
|||
|
|||
#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
|
|||
|
|||
#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
|
|||
|
|||
#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 | |
|
|