Thread: =IF(OR question
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default =IF(OR question

One way:

=IF(OR(B6=0,B7=0, B6<B7),"",B6-B7)




In article ,
Jock wrote:

Hi,
Having a problem here. Essentially: In cell B9
=IF(either B6 OR B7=0,"",If(B6<B7,"",B6-B7)
Can someone sort this one out for me?

Thanks