Using IF and OR formulas to get a single output

Put an IF statement around the OR statement: IF( OR(whatever this is), “YES”, BLANK())

@David_Skinner thanks! What am I missing here? I may have the OR statement in the incorrect place.

This doesn’t return any output:

IF(Email = BLANK(), IF(OR(Phone = BLANK()), “”, “YES”))

Sorry, I hadn’t checked it myself.

As Jonathon says, it seems you can’t use BLANK() as a comparison. I thought I had in the past, but perhaps not.

Hmm, still not working. I pasted it exactly and got an error :confused:

Thanks for your help with this, btw

Just to clarify - the error in red there is related to the double quotes around the YES. They are formatted and not plain text, so this gives an error. However, even if you replace with plain text quotes the formula does not work (it gives an output, but not the correct output). I’m guessing you can’t use BLANK() as a comparison value, just an output value - anybody know?

@JonathanBowen hey, thank you and that worked :slightly_smiling_face: Is there a time I should use BLANK() vs. just a ’ ’ ? Your and @David_Skinner 's formulas were exactly the same except for the BLANK() vs ’ ’

Yeah, not sure why this would be but it looks like you can use BLANK() to output a blank value, but you can’t say if X = BLANK()

Sorry, I hadn’t checked my formula before posting. I’ve accidentally deleted it now as well.

As Jonathan says, it seems you can’t use BLANK() as a comparison. I thought I had in the past, but perhaps not.

Cool, thank you both. That’s where I was getting really stuck – I didn’t realize that there were cases where = BLANK() might not work as opposed to = ’ ’