vendredi 16 septembre 2016

IF Statements with Dates in Excel

I am trying to create a formula for Contract Certainty the rules are as follows:

A - Order is before inception and Completed before inception B - Order is before inception but completed after inception C - Order is after inception and completed after inception

I have three columns: Inception (Column I), order (Column O) and Completed (Column P) and the cells are formatted to short date.

I have created the following formula constructed from IF statements.

=IF(AND(I101>O101,I101>P101),"A",IF(AND(I101>O101,I101<P101),"B",IF(AND(I101<O101,I101<P101),"C")))

However, the formula is returning 'False' rather than a letter grading.

Any help would be greatly appreicated.

Thanks :)

Aucun commentaire:

Enregistrer un commentaire