Thread: =IF(OR question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default =IF(OR question
How about: =IF(OR(B6=0,B7=0),"",IF(B6<B7,"",B6-B7))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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
Reply With QuoteReply With Quote