Nested if statements

[andie91]

Hi everyone.

I would be grateful if you could help with the two questions below.

1) If I had two columns not adjacent to each other e.g. a1 and c1. If a1 and c1 had dates entered i.e. not blank, what function would I use to put a yes response in column d1, but also put in a no response in d1 if either a1 or c1 were blank. 2) if i had four columns e.g. a1 is a date for event 1, b1 is a time for event 1, c1 is a date for event 2 and d1 is a time for event 2. How can i calculate whether event 2 happened less than or equal to 20 minutes from event 1. Thank you

<tbody data-remaining-comments-count="0" data-canpost="true" data-cansee="false" data-comments-unavailable="false" data-addlink-disabled="false" style="margin: 0px; padding: 0px; border: 0px;">
</tbody>

 

[Aladin Akyurek]

1.

=IF(COUNT(A1,C1)=2,"yes","no")

2. Probably...

=IF(A1 = C1, IF(D1>=B1,D1-B11,0),0)>="0:20"+0<strike></strike>

 

[steve the fish]

Don't think the 2nd one would work should time pass over a day. Maybe one of these depending on whether it matters which event needs to come first or not.

=(A1+B1-C1-D1)*1440<=20
=ABS(A1+B1-C1-D1)*1440<=20