Hi

I am trying to create a formula in my spreadsheet that evaluates two fields
and generates a string based on the evaluation.

Each field can contain one of three values - "Complete", "n/a" or "" (blank)

I then want to evaluate two fields that both have this criteria and return
the string "Complete" if both evaluations return true or "Incomplete" if one
or more return false.

I have developed the following formula but it is not working

=IF(AND((OR(A1="Complete","n/a")),(OR(B1="Complete","n/a"))),"Complete","Incomplete")

Is there a way this can be done?

any help much appreciated!