Thread: =IF(OR question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noob Jedi Noob Jedi is offline
external usenet poster
 
Posts: 33
Default =IF(OR question

On Aug 28, 10:22 am, 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

--
Traa Dy Liooar

Jock


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