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
------------------------------
Question
IF Formula Help
This topic has been closed for replies.
+24try 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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.