Hello,
I’m hoping someone can help with a formula issue. Im using a If(Or) formula and it works fine with the first 2 conditions but when I add a 3rd one is not. Im not sure what I’m doing wrong.
This is the formula with the first 2 conditions:
IF(OR(DAYS({Fingerprinting Due Date},TODAY())>=300),(DAYS({Central Registry Due Date},TODAY())>=300),“Y”,“N”)
and this is the result:
When I add another criteria:
IF(OR(DAYS({Fingerprinting Due Date},TODAY())>=300),(DAYS({Central Registry Due Date},TODAY())>=300),(DAYS({TB Test Due Date},TODAY())>300),“Y”,“N”)
It returns “true” everywhere as opposed to the required “Y” or “N” values.
Thanks!