# Help with Conditional Statement (Calculated Column)

I have created a sharepoint workbook with contract information. Three columns in this sharepoint have dates. ([Planned Release Date] , [Revised Release Date] , and [Current Release Date]). I have another column, [On Track], that uses if statements to determine the value for this column, the choices are: "Yes", "No", or "" (blank).

The criteria for the [On Track] column is as follows: If [Planned Release Date] or [Current Release Date] is blank, then [On Track]=""(blank) If [Current Release Date]<=[Planned Release Date] OR [Current Release Date]<=[Revised Release Date] then [On Track]="Yes" If [Curent Release Date]>[Planned Release Date] AND [Current Release Date]>[Revised Release Date] then [On Track]=No

The formula I've written fails when [Current Release Date]>[Planned Release Date] BUT [Current Release Date]<=[Revised Release Date]. (It says the row is Not On Track even though the [Current Release Date]<=[Revised Release Date]).

Here is the formula I have put into sharepoint currently:

=IF(OR([Current Release Date]="",[Planned Release Date]=""),"",IF(AND([Current Release Date]>[Planned Release Date],[Current Release Date]>[Revised Release Date]),"No",IF(OR([Current Release Date]<=[Revised Release Date],[Current Release Date]<=[Planned Release Date]),"Yes")))

Do you see a problem with my formula? Any help / advice is greatly appreciated. Thanks

• Excel can be useful for sorting out logic issues for calculated columns as it's basically the same syntax. Commented Jun 14, 2013 at 19:49

``````=IF(OR([Current Release Date]="",[Planned Release Date]=""),"",IF(AND([Current Release Date]>[Planned Release Date],[Current Release Date]>[Revised Release Date]),"No","Yes"))