ExcelBanter - if else construct

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if else construct (https://www.excelbanter.com/excel-worksheet-functions/36257-if-else-construct.html)

Ian Bartlett

if else construct

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(A1TODAY(),16,0)

"Ian Bartlett" wrote in message
news:tJeDe.275408$El.125787@pd7tw1no...
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

Ian Bartlett

Barb, that's is exactly what I wanted

Thank you
"Barb Reinhardt" wrote in message
...
Is this what you want?

=IF(A1TODAY(),16,0)

"Ian Bartlett" wrote in message
news:tJeDe.275408$El.125787@pd7tw1no...
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

All times are GMT +1. The time now is 12:55 AM.