If / or/ then

[Bill]

Cell D24 will either be blank or will have NON-OP in it.
Cell E24 will either be blank or will have a time (HH:MM)
in it.
If Cell E24 has a time in it F24 will have a later time
in it. G24 will be the elapsed time between E24 & F24.


In the example below
=IF(D24=NON-OP,3,IF(G24<=$D$60,0,"1"))
Cell D24 has text NON-OP so in cell N24 the figure 3
should appear in cell N24 UNLESS there is data (in HH:MM)
in E24. (it does)

If there is data added manually to E24, (D24 will not
have NON-OP in it)then I want the second part of the
formula should take over
ie from IF(G24<=$d$60,0,"1")

There are several more cells on line 24 following the
same pattern.

I wrote the formula (below) down but I am missing
something after the 3 (the value_if_false)
What I want to go in "the value_if_false is the arguement
IF(G24<=$D$60,0,"1")) but having entered it there, the
cell that should put in either 3 0 or 1 just shows the
formula.

If someone could review and suggest appropriately I would
be very grateful
Bill

 

[JulieD]

Hi Bill

just confirming the outcomes
if D24 has NON-OP and E24 has time (HH:MM) then N24 should show 1
if D24 has NON-OP and E24 blank then N24 =3
in D24 blank and E24 has data then N24 = IF(G24<=$d$60,0,"1")

so how about
=IF(D24="NON-OP",IF(E24<>"",1,3),IF(G24<=$D$60,0,1))
- note i've made 1 numeric in the above statement.

Cheers
JulieD

 

[Bill]

JulieD
If you read this, Thanks - it works a treat
If you don't read it, I hope telepathy is a reality

Regards
BillT

 

[JulieD]

Hi Bill

thanks for the feedback, i'm glad it worked.

Cheers
JulieD