View original (French)

If understood within two hours

Solved
logas -  
 logas -
Hello,

In cell B8, I have a time for example: 08:00
In cell L8, I have another time incremented by 1/4 hour compared to B8

Now I want that when B9 = 8:12 for example, it marks "no" in cell M8.
If B9 = 8:15 or more, it marks "yes" in cell M8.

I tried this:
in M8: =IF(B8<>0," yes","")
in M9: =IF(AND(B9>=L8)," yes"," no")

It seems to work, but when I copy the formula to other cells, there are "YES" marked everywhere.

I would like that when I leave B10 empty, M10 does not show anything.

Thank you for your help.

5 answers

Answer 1 / 5
Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 146
 
Hello,

If I understand correctly,
in B8 this formula
=IF(B9>=L8,"YES","NO")

--
See you later
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.
0