Hide #Value!

  • Thread starter Thread starter brainstewn
  • Start date Start date
B

brainstewn

=IF(H38=0,"",(($C59+C60)/$H38))

I've read the techniques for hiding the #Value! when empty but need help. I
tried doing it with ideas in the forum but it's not working the way I do it.
Please help.

Ciao
Darrell
 
=IF(H38=0,"",(($C59+C60)/$H38))

If there are TEXT entries in any of those cells then you'll get the #VALUE!
error. How to deal with that depends on what result you want if 1, 2 or all
3 of the cells are either empty or contain text.

Try this:

=IF(H38=0,"",IF(ISNUMBER(H38),SUM($C59:C60)/$H38,""))
 
Back
Top