2 if(and statements

[debralee]

GOOD AFTERNOON,
I HAVE STRUGGLED ENOUGH TRYING THIS NOW ITS TIME TO ASK THE GURUS.

WORKING WITH 2 COLUMNS:
F WILL ONLY CONTAIN 0 OR 1
H WILL ONLY CONTAIN YES OR NO

SHOULD IT BE IF AND OR? PLEASE HELP

=IF(AND(F3="1",H3="Yes"),"COMPLETE","INCOMPLETE",IF(AND(F3="0",H3="No"),"COMPLETE","INCOMPLETE")

1,YES COMPLETE
O,NO COMPLETE
0,YES INCOMPLETE
1,NO INCOMPLETE

 

[Fluff]

If F contains numbers rather than text try
=IF(OR(AND(F3=1,H3="Yes"),AND(F3=0,H3="No")),"COMPLETE","INCOMPLETE")

 

[Marcílio_Lobão]

debralee, Good evening.

-------------------------------------------------
Please, don't write your message in capital letters.
-------------------------------------------------

Try to use:

=IF(F3=1,IF(H3="YES", "Complete", "Incomplete"), IF(H3="NO", "Complete", "Incomplete" ))

Is that what you want?
I hope it helps.

Ps.: The formula of the message above is more elegant than mine.
. . . .Choose Fluff's formula.

 

[debralee]

If F contains numbers rather than text try
=IF(OR(AND(F3=1,H3="Yes"),AND(F3=0,H3="No")),"COMPLETE","INCOMPLETE")

This is perfect Thank you very much!

Sorry for the Caps

 

[Fluff]

Glad we could help & thanks for the feedback