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

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

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

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

Does this help?
Kostis Vezerides

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

which has the higher priority?
Can J4 = D14 and also be E14?
Can J4 beE14 and E14 be D14?

If the answer is no to both or if the priority is similar to the order you
entered the relationships
=if(J4=D14,1,if(J4E14,0,if(and(J4D14,E14D14),0. 5,otherwise)))

"keyinput" wrote:

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

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?

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?