Add a third state

You can reply conditions from F1 in another IF formula:
[tt]=IF(AND(A1="Yes",B1="Yes",C1="Yes",D1="Yes"),"Submitted","")[/tt]
or continue chain:
[tt]=IF(F1<>"","Submitted","")[/tt]

combo

Paul said:

Let imagine the value of N5 sits in Cell F1.

Click to expand...

Huh?

How about the value of N5 is in cell N5.

Also, how about doing Boolean logic wish Boolean values instead of text.

PaulColbert,
You need to re-state your requirements because your (current) formula creates an error:



Same sample data presenting your issue would be nice

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

I assumed that the formula: [tt]=IF(AND(A1="Yes",B1="Yes",C1="Yes",D1="Yes"),N5,"")[/tt] is in F1 (Let imagine the value of N5 sits in Cell F1), next OP plans to conditionally fill E1 (when all this is done put text in Cell E1 to say the word- 'Submitted'). Looking at the later posts, OP should be more clear in describing the problem.

combo