=IF(OR(J4=D143,J4E14,AND(J4D15,J4<E14)),0.5,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"keyinput" wrote in message
...
IF J4=D14,1 or if J4E14,0 or if J4D14<E14,0.5 how do I make this work?