Hide #Value!

[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

 

[T. Valko]

=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,""))

 

[Kassie]

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

--
HTH

Kassie

Replace xxx with hotmail

 

[Kassie]

The 3 was a slip, obviously it should also be 38
--
HTH

Kassie

Replace xxx with hotmail