maybe this will do for you..........

=IF(AND(J4D14,J4<E14),0.5,IF(OR(D14<J4,D14K4),0, 1))

Vaya con Dios,
Chuck, CABGx3



"keyinput" wrote:

Thank You - that worked I just need to add ,0 as the false on the last
statement.

Last Problem: currently using
=IF(OR(D14<J4,D14K4),0,1)
I also need this statement to include J4D14 AND <E14 RETURN 0.5


"CLR" wrote:

=IF(J4=D14,1,IF(J4E14,0,IF(AND(J4D14,J4<E14),0.5 )))

Vaya con Dios,
Chuck, CABGx3




"keyinput" wrote:

IF J4=D14,1 or if J4E14,0 or if J4D14<E14,0.5 how do I make this work?