AND and OR in a single formula

T

Tom

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!
 
B

Biff

Hi!

Try this:

=IF(AND(OR(A1={"Complete","N/A"}),OR(B1={"Complete","N/A"})),"Complete","Incomplete")

Biff
 
R

Rowan

Try

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

Regards
Rowan
 
R

Ragdyer

Try this:

=IF(AND(OR(A1={"Complete","n/a"}),OR(B1={"Complete","n/a"})),"Complete","Inc
omplete")
 
Top