Forum Discussion

Braddo777's avatar
Braddo777
Copper Contributor
Jun 14, 2022

If And function

I would like to use an IF, AND and ISTEXT function. 

 

=IF(AND(ISTEXT(H7), ISTEXT(O14)), "Completed", =H7-90)

 

Target cell is to display H7 minus 90 days or Completed if O14 has a date

H7 is a date

O14 is a cell where a completed date is to be put

excel
  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor
    Jun 15, 2022

    Braddo777  wrote:  =IF(AND(ISTEXT(H7), ISTEXT(O14)), "Completed", =H7-90)

     

    You almost got it!  The second equal sign does not belong.  Write:

     

    =IF(AND(ISTEXT(H7), ISTEXT(O14)), "Completed", H7-90)

     

    But I wonder if you should use OR instead of AND.   What if H7 is text, but O14 is not?

     

    Also, note that ISTEXT(H7) returns FALSE if H7 is empty (no value).  In that case, the formula returns -90.  Is that okay?

     

    PS....  As a wild guess, I wonder if the following works better for you:

     

    =IF(AND(ISNUMBER(H7), ISNUMBER(O14)), H7-90, "Completed")

     

     

     

Resources