IF OR functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

keyinput - 17 Oct 2006 13:10 GMT

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

Reply to this Message

CLR - 17 Oct 2006 13:46 GMT

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

Vaya con Dios,
Chuck, CABGx3

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

Reply to this Message

keyinput - 17 Oct 2006 21:45 GMT

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,D14>K4),0,1)
I also need this statement to include J4>D14 AND <E14 RETURN 0.5

> =IF(J4=D14,1,IF(J4>E14,0,IF(AND(J4>D14,J4<E14),0.5)))
>
> Vaya con Dios,
> Chuck, CABGx3
>
> > IF J4=D14,1 or if J4>E14,0 or if J4>D14<E14,0.5 how do I make this work?

Reply to this Message

CLR - 18 Oct 2006 17:53 GMT

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

=IF(AND(J4>D14,J4<E14),0.5,IF(OR(D14<J4,D14>K4),0,1))

Vaya con Dios,
Chuck, CABGx3

> Thank You - that worked I just need to add ,0 as the false on the last
> statement.
[quoted text clipped - 9 lines]
> >
> > > IF J4=D14,1 or if J4>E14,0 or if J4>D14<E14,0.5 how do I make this work?

Reply to this Message

Bob Phillips - 17 Oct 2006 13:48 GMT

=IF(OR(J4=D143,J4>E14,AND(J4>D15,J4<E14)),0.5,0)

Signature

HTH

Bob Phillips

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

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

Reply to this Message

vezerid - 17 Oct 2006 13:48 GMT

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

Does this help?
Kostis Vezerides

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

Reply to this Message

bj - 17 Oct 2006 16:24 GMT

which has the higher priority?
Can J4 = D14 and also be > E14?
Can J4 be>E14 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(J4>E14,0,if(and(J4>D14,E14>D14),0.5,otherwise)))

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

Reply to this Message