#value! Error

  • Thread starter Thread starter sony654
  • Start date Start date
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))
 
Back
Top