1

I have a list which has [Status] and [% Complete] as columns.

In the [% Complete] column, I added a validation rule to pass validation when [Status]="Complete" AND [% Complete]=100, otherwise retunr an error.

My formula is: 

=IF(AND([Status]="Complete",[% Complete]=100), "OK", "NOT OK")

But it's generating an error, what am I missing?

Ali Jafer
  • 17,808
  • 1
  • 27
  • 41
user15805
  • 11
  • 1
  • 2

1 Answers1

1
=IF(AND(Status="Completed",[% Complete]=1),"OK","NOT OK")

This works for me. Note that 100% is 1 not 100. Also that the standard is "Completed" and not "Complete" though this will depend on whether you have customised the choices.

However, that said, I do not really see anything wrong with your formula that would cause an error.

Dave Paylor
  • 4,019
  • 2
  • 14
  • 8