IF OR functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Vaya con Dios,
Chuck, CABGx3
 
=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)
 
=IF(J4=D14,1,IF(J4>E14,0,IF(AND(J4>D14, D14<E14),0.5)))

Does this help?
Kostis Vezerides
 
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)))
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to Time conversion 3
Simplfying DIV/0 Error...Can you? 4
Absolute cell reference will not remain absolute. 1
IF statement too long, need another way 4
IF AND VLOOKUP formula needed 1
simple question on formulas and autofil 1
Dynamic data ranges 3
Add years NOT days 3

Back
Top