Forum Discussion
Solved
If Cell ISBLANK then look at other Cell
Hello Everyone, I have a starting date (Sheet1!F8), and 2 dates to compare to (A6, and A7), If A6 or A7 is later than Sheet!F8, I want a name to display in the field (imported from Sheet1!F6). Ho...
So, you have two lesson dates in A6 and A7 (or that could be more, in A8, A9, etc.?). If the latest non-blank lesson date is greater or equal to starting date you display the name, otherwise nothing. Correct?
If so the formula could be
=IF(MAX(A6:A7)>=Sheet1!F8,Sheet1!F6,"")
Hi Sergei, Thanks, that is of great help! I added the equal symbols: =IF(AND(A6>=Sheet1!F8,OR(A7>=Sheet1!F8,ISBLANK(A7))),Sheet1!F6,"")
Now I somehow have 1 minor issue. If the starting date is the same as the date in A7, the name disappears, despite having the >= symbol. Do you know what is happening? Thank you so much for all your help!!
Martin, it shall work
Are you sure A6 is not less than starting date?