Thread: =IF(OR question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default =IF(OR question

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

however do you want zero if B6=B7, if not change the formula to

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



--
Regards,

Peo Sjoblom




"Jock" wrote in message
...
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