# Using IF and OR formulas to get a single output

Topic Labels: Formulas
Solved
2076 11
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hi, I have had a lot of success using formulas in the past, but I am stumped on how to properly format the following:

I have three columns: Email, Phone, and Wants Follow Up?

I have been stumped on making a formula where IF the Email cell OR the Phone number cell is filled out (AKA not blank), then the output will be a YES in the Wants Follow Up? cell.

I know I must be making an simple mistake, because the formulas I have tried only give a YES output if both the Phone and Email cells are filled out, not either-or.

The actual OR formula as shown on the Airtable help section just outputs a 1, but I want YES text to be shown, not a 1.

What am I not doing correctly? Thanks!

1 Solution

Accepted Solutions
13 - Mars

Think you want something like this:

`IF(OR(Email != '', Phone != ''), 'Yes', '')`

11 Replies 11
9 - Sun

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

5 - Automation Enthusiast

@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.

5 - Automation Enthusiast

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

5 - Automation Enthusiast

Thanks for your help with this, btw

13 - Mars

Think you want something like this:

`IF(OR(Email != '', Phone != ''), 'Yes', '')`

13 - Mars

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?

5 - Automation Enthusiast

@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()