I would like to create an if/ then statement =IF([Launch Date]5 > [Start Date]5) = 1

Tom Jones

Essentially asking it to compare 2 dates. If the first is larger, then give a 1. If the second is larger give 0.

Frank Falco

=if([Launch Date]5 > [Start Date]5,1)

if you are going to have this on every row then use

=if([Launch Date]@row > [Start Date]@row,1)

You can use this even for one row. It is more efficient.

Also, you can optionally add a false value, so it you wanted to make it return 0 when false then

=if([Launch Date]@row > [Start Date]@row,1,0)

Frank Falco

=if([Launch Date]5 > [Start Date]5,1)

if you are going to have this on every row then use

=if([Launch Date]@row > [Start Date]@row,1)

You can use this even for one row. It is more efficient.

Also, you can optionally add a false value, so it you wanted to make it return 0 when false then

=if([Launch Date]@row > [Start Date]@row,1,0)

Tom Jones

Thanks Frank this helps.