Forum Discussion
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). However, If A6 is later than the starting date, but A7 is still blank, I still want the name to display.
I came up with the following formula, but, obviously as I wouldn't be asking for help, isn't working:
=IF((ISBLANK(A7),(AND(A6>=(Sheet1!F8),(Sheet1!F8)>0),(Sheet1!F6),""), (Sheet1!F6))
Could anyone help me solve this puzzle?
Thank you so much for your consideration and time.
Kind regards,
Martin
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 Martin,
It could be
=IF(AND(A6>Sheet1!F8,OR(A7>Sheet1!F8,ISBLANK(A7))),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?
