Thread: Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 to be
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 to be
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?
Reply With QuoteReply With Quote