if else construct

[Ian Bartlett]

Hello Guru's

if A1 which is a date, I want to place in B1 16 if that date is greater than
today if not 0


Thanks in advance Bart

 

[Barb Reinhardt]

Is this what you want?

=IF(A1>TODAY(),16,0)

 

[Ian Bartlett]

Barb, that's is exactly what I wanted

Thank you

Is this what you want?

=IF(A1>TODAY(),16,0)