IF OR functions

B

Bob Phillips

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

--
HTH

Bob Phillips

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

vezerid

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

Does this help?
Kostis Vezerides
 
B

bj

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)))
 
K

keyinput

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
 
C

CLR

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
 
Top