IF Formula Help

Question

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, then my [formula field]=no
However, if [daytime]=yes OR [evening]=yes, then my [formula field]=yes

Does anyone have any ideas? Thank you in advance!

------------------------------
Gabriella Tremoglie
------------------------------

markshnier__you · Answer

try thisIF([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.&nbsp;&nbsp;------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

gabriellatremog · Answer

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__you · Answer

The test on equals =&nbsp; is case sensitive.&nbsp; Can you check the Capitalization of your fields.&nbsp; Are they for example Yes or YES where our formula is testing for yes.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

gabriellatremog · Answer

Ah - that was it! Great call, thank you. I had "Yes" where our formula was testing for "yes".&nbsp;Works perfectly now. Thanks for your help!------------------------------Gabriella Tremoglie------------------------------

Forum Discussion

IF Formula Help