Help with a If statement

[divster27]

Hi - i'm trying to write what i believe to be a simple statement, but can't work out why I'm getting an error

IF(I2<TODAY() and U2<>"Complete", "True", "False")

If the value in I2 is before today's date AND the value in U2 is not equal to Complete, return true
if not false

David

 

[Sparcot]

Hello. Try this: =IF(AND(I2<TODAY(),U2<>"Complete"), "True", "False")

 

[Georgiboy]

=IF(AND(I2<TODAY(), U2<>"Complete"), "True", "False")

 

[divster27]

thanks both
worked a treat

 

[divster27]

ignore

 

[Fluff]

FWIW you could also get rid of the IF & leave the values as logical values rather than text

=AND(I2<TODAY(), U2<>"Complete")