Add a third state

[PaulColbert]

Hi,
I have this formula which pulls in the value of Cell N5.

=IF(AND(A1="Yes",B1="Yes",C1="Yes",D1="Yes"),N5,"")


Let imagine the value of N5 sits in Cell F1.
Am I able to rearrange this formula to add a third state to say "when all this is done put text in Cell E1 to say the word- 'Submitted'
Thanks in Advance

 

[combo]

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

 

[mintjulep]

Let imagine the value of N5 sits in Cell F1.

Huh?

How about the value of N5 is in cell N5.

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

 

[Andrzejek]

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

 

[combo]

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