#value! Error

S

sony654

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#N/A Error w/LOOKUP Function 6
Macro to "find" the next empty cell in a range 2
Another Issue With A Function 3
adding rows into the table 1
Use TODAY() function as the criteria in a SUMIF formula 1
Newbie Help - IF Yes No Function 0
How do I define a range using values in cells? 2
#DIV/0! Error 11

Top