Forum Discussion

Amir '-'s avatar
Amir '-
Copper Contributor
Jan 23, 2018
Solved

Need Help to write Excel formula

If(E2 > TODAY() && H2 == "Yes" && (E2 - TODAY()) >= 1){ Cell.Value = "true" } else{ cell.Value = "false" } E2 is a date column H2 is a text column I need to write excel formul...
Formulas & Functions
training
  • Willy Lau's avatar
    Willy Lau
    Jan 23, 2018
    =IF(AND(E2>INT(NOW()),H2="Yes",(E2-INT(NOW()))>=1),TRUE,FALSE)
Willy Lau's avatar
Willy Lau
Steel Contributor
Jan 23, 2018
=IF(AND(E2>INT(NOW()),H2="Yes",(E2-INT(NOW()))>=1),TRUE,FALSE)