IF Formula Help
Hello - hoping someone can provide some assistance. I'm trying to create a formula field that gives a Yes/No output based on the answer of two other fields. If [daytime]=no AND [evening]=no, t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
IF(
[daytime]="no" AND [evening]="no", "no",
[daytime]="yes" OR [evening]="yes", "yes")
Note that if either of the two fields, [daytime] or [evening] are blank than this formula will result in blank.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
IF(
[daytime]="no" AND [evening]="no", "no",
[daytime]="yes" OR [evening]="yes", "yes")
Note that if either of the two fields, [daytime] or [evening] are blank than this formula will result in blank.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Thanks Mark. Neither of the fields are blank, but this formula is still resulting in blank.
If(
[Daytime]="no" and [Evening]="no", "no",
[Daytime]="yes" or [Evening]="yes", "yes")
I should note that both my [daytime] and [evening] fields are already formula-text fields. Not sure if that makes a difference.,
------------------------------
Gabriella Tremoglie
------------------------------- MarkShnier__YouThe test on equals = is case sensitive.
Can you check the Capitalization of your fields. Are they for example Yes or YES where our formula is testing for yes.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Ah - that was it! Great call, thank you. I had "Yes" where our formula was testing for "yes".
Works perfectly now. Thanks for your help!
------------------------------
Gabriella Tremoglie
------------------------------
