How to write a multiple conditional formula with IF

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?

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

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:

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

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

And away I go!

Rob