I’m trying to create a formula that looks for either of 2 fields to be checked. Can someone tell me what I’m doing wrong? I can get it to work with either/or but trying to look up both, I’m stumped. Thank you!
IF((Agreement =1) OR(IF{Umbrella Agreement}=1)),“ :smiling_face_with_sunglasses: ”
Best answer by JonathanBowen
The format of the OR is the same as the AND, i.e.:
IF(OR({Agreement} = 1, {Umbrella Agreement} = 1), 'Success', 'Failure')
+19Hello! Breaking it down, you would format it as follows to consider two criteria:
Edited
AND statement
AND((Agreement =1), ({Umbrella Agreement}=1))
or
OR((Agreement =1),(IF{Umbrella Agreement}=1))
Then, adding in the IF you would write this like :
IF(OR((Agreement =1), (IF{Umbrella Agreement}=1))," ^_^ ")
Hope that helps
NB (This is just formulas from memory - So may not be completely correct, but hopefully it will at least show you how to structure a formula like this.
Hello! Breaking it down, you would format it as follows to consider two criteria:
Edited
AND statement
AND((Agreement =1), ({Umbrella Agreement}=1))
or
OR((Agreement =1),(IF{Umbrella Agreement}=1))
Then, adding in the IF you would write this like :
IF(OR((Agreement =1), (IF{Umbrella Agreement}=1))," ^_^ ")
Hope that helps
NB (This is just formulas from memory - So may not be completely correct, but hopefully it will at least show you how to structure a formula like this.
Tried all those and still not working. Sorry, I’m so new to this.
+18The format of the OR is the same as the AND, i.e.:
IF(OR({Agreement} = 1, {Umbrella Agreement} = 1), 'Success', 'Failure')
+19That worked!! Many thanks.
That was my copy paste mistake, sorry! Thanks @JonathanBowen
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
