=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
|