Add a third state
Add a third state
(OP)
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
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
RE: Add a third state
=IF(AND(A1="Yes",B1="Yes",C1="Yes",D1="Yes"),"Submitted","")
or continue chain:
=IF(F1<>"","Submitted","")
combo
RE: Add a third state
Huh?
How about the value of N5 is in cell N5.
Also, how about doing Boolean logic wish Boolean values instead of text.
RE: Add a third state
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
RE: Add a third state
combo