if else construct

Ian Bartlett · Jul 19, 2005

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 · Jul 20, 2005

Is this what you want?

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

Ian Bartlett · Jul 22, 2005

Barb, that's is exactly what I wanted

Thank you

Barb Reinhardt said:
Is this what you want?

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