List validation on multiple fields?

Question

I would like to validate a list item so that if one field is true, then another must be completed. If the first one is false, then it can be ignored.

=(([Start Deferment]="Specific Date") AND [Start Deferment Date] > TODAY()) OR ([Start Deferment]="Next Payment")

This gives an error, so I am guessing my syntax is incorrect?

Answer 1

It appears the validation formulae are similar to Excel:

=OR(AND([Start Deferment]="Specific Date",[Start Deferment Date]>TODAY()),[Start Deferment]="Next Payment")