Forum Discussion

Mark_reg's avatar
Mark_reg
Brass Contributor
Jun 12, 2018
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...
Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 12, 2018

    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,"")

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 12, 2018

Hi Martin,

 

It could be

=IF(AND(A6>Sheet1!F8,OR(A7>Sheet1!F8,ISBLANK(A7))),Sheet1!F6,"")
  • Mark_reg's avatar
    Mark_reg
    Brass Contributor
    Jun 12, 2018

    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!!

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 12, 2018

      Martin, it shall work

      Are you sure A6 is not less than starting date?

       

      • Mark_reg's avatar
        Mark_reg
        Brass Contributor
        Jun 12, 2018

         

         

        For me it isn't working. For the names: Jack starts at 2018-06-12, and the second (Annie) starts at 2018-06-13. However, Annie isn't showing despite me using the exact formula.

         

         

        Does it work for you because both your dates are the same?

         

Resources