Hide #Value!
 

=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

Hide #Value!
 

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


--
Biff
Microsoft Excel MVP


"brainstewn" wrote in message
...
=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

Hide #Value!
 

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

--
HTH

Kassie

Replace xxx with hotmail


"brainstewn" wrote:

=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

Hide #Value!
 

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

Kassie

Replace xxx with hotmail


"brainstewn" wrote:

=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