Help

How to write a multiple conditional formula with IF

Topic Labels: Base design
2672 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Rob_Cahill
6 - Interface Innovator
6 - Interface Innovator

Dear Airtable Community,

I am trying to edit a formula with IF to make it capture the conditions of two or more fields. I have two fields that are either empty or not empty.

This is the formula I am using for one field and it works just fine:
IF({Constancia}, TRUE(), FALSE())
How can I edit this formula to have it work for two or more fields?

I am new to Airtable so please spell it out for me. (sorry)

I thank you in advance of your help with this question.

Rob

5 Replies 5
Eli_Kent
7 - App Architect
7 - App Architect

Rob, it should depend on what you want the new formula field to do.

As far as I understand, that formula reads “If there is data in {Constancia}, return ‘1’ and if there is no data, return ‘0’”

But you have another field - {Other} let’s say.

For {Other} will it also be a data or no data question?
What do you want the formula to do if there is data in both {Constancia} and {Other}? Or neither?

Rob_Cahill
6 - Interface Innovator
6 - Interface Innovator

Hi Eli_Kent, Thanks. {Constancia} is one field and it will be either empty or not empty. The other field is {Report Card} and it is either empty or not empty.

I want a formula that will return 1 if both fields are not empty and return 0 if either field is empty.

does that make sense? Thank you for your help.

Rob

Rob_Cahill
6 - Interface Innovator
6 - Interface Innovator

I apologize. My question needs clarification.

I have a table with multiple fields. Two fields are for documents: “Recommendation Letter” and “Report Card” I would like to add a field with a formula that will show me that both fields are not empty.

{Rec Letter} is one field and it will be either empty or not empty. The other field {Report Card} and it is either empty or not empty.

I need a formula that will return 1 if both fields are not empty and return 0 if either field is empty.

Thank you for your help.

Rob

Use the AND() function to combine more than one condition:

IF(AND(Constancia, {Report Card}), TRUE(), FALSE())

You can pack as many conditions into AND() as you want. Same thing with its counterpart, OR(). For more on these, check out this video:

Thank you Justin_Barrett. This answers my questions perfectly!!!

And away I go!

Rob