Hi,

If you want to do it with conditional formatting then you can by setting the
font colour to white (same as background) if either cell is empty. The zero
is still returned but you won't see it.

Use this conditional format formula in your formula cell.

=COUNT(B6,B7)<2


Mike

"Mike H" wrote:

Try,

=IF(COUNT(B6:B7)<2,"",SQRT(POWER($B$6,2)+POWER(B$7 ,2)))

Mike

"Dr. Darrell" wrote:

I have a formula in Cell D12:

=SQRT(POWER($B$6,2)+POWER(B$7,2))

If in have no entry in Cell B6 or B7, I would like cell D12 to be blank.

I think it should be done with Conditional Formatting, but how do I identify
or recognize a blank (no entry) cell?