Forum Discussion

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 formula based on codes posted above.

=IF(AND(E2>INT(NOW()),H2="Yes",(E2-INT(NOW()))>=1),TRUE,FALSE)

Willy Lau
Steel Contributor
Jan 23, 2018
=IF(AND(E2>INT(NOW()),H2="Yes",(E2-INT(NOW()))>=1),TRUE,FALSE)