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