# Formula IF+AND with multiples conditions

Topic Labels: Formulas
Solved
817 7
cancel
Showing results for
Did you mean:  4 - Data Explorer

Hello :slightly_smiling_face:
I am a beginner in the creation of Airtable formulas.
Is it possible to create a formula IF(AND(value1,value2,value3) with at least 3 conditions ? I only succeeded it with 2 conditions.
If it’s not possible, do you know how i can make it with others formulas ?

Tx u very much for your help/time

1 Solution

Accepted Solutions  6 - Interface Innovator

Hi Mathilde. If there are only two values for {CONTRAT}, CDI & CDD, then you could use the formula…

This will leave the field empty if {CONTRAT}=“CDD”. There’s no option to type in a value in a formula field. Good luck.

7 Replies 7  6 - Interface Innovator

Hi. It’s definitely possible. Can you show your field values and the formula? If not, can you explain what the three “values” are? They can be boolean expressions as well if you need them to be.  4 - Data Explorer

Hi Chris, there is my actual formula working :slightly_smiling_face:
IF(AND({ENTITE}=“ONATERA”,{STATUT} =“Cadre”), 3, IF(AND({ENTITE}=“ONATERA”,{STATUT} =“Agent de maîtrise”),2,IF(AND({ENTITE}=“ONATERA”,{STATUT} =“Employé”),1,IF(AND({ENTITE}=“OVALENTINA”,{STATUT} =“Cadre”),3, IF(AND({ENTITE}=“OVALENTINA”,{STATUT} =“Agent de maîtrise”),2,IF(AND({ENTITE}=“OVALENTINA”,{STATUT} =“Employé”),1,IF(AND({ENTITE}=“BIOULTIME”,{STATUT} =“Cadre”),4, IF(AND({ENTITE}=“BIOULTIME”,{STATUT} =“Agent de maîtrise”),3,IF(AND({ENTITE}=“BIOULTIME”,{STATUT} =“Employé”),2)))))))))

I would like to add an other condition like IF({CONTRAT}=“CDD”) none of the previous formulas apply and you must enter by hand in the field. Is it possible ?

It’s really hard to explain , hope you understand the point …  4 - Data Explorer

What doeas it mean boolean expressions ?  6 - Interface Innovator

A boolean expression is any combination of objects & operators that result in a true/false outcome. You use them in your formula in many places (e.g. {STATUT}=“Employé”).

So, your formula is straightforward, but difficult to look at. :grinning: You could simplify it a little, since in both cases where {ENTITE} != ‘BIOULTIME’, the results of the {STATUT} field determine the results. So, it can be simplified to the following, if it helps you to do so:

Can you tell me where you would like to consider the value of {CONTRAT}?  4 - Data Explorer

Thank u for the tip, i’ll try it
If the {CONTRAT}=“CDI” i want to appply all the previous formula but IF {CONTRAT}=“CDD” i would like to let the field empty or the best of the best (but I don’t know if it’s possible) would like to let yourself enter the data  6 - Interface Innovator

Hi Mathilde. If there are only two values for {CONTRAT}, CDI & CDD, then you could use the formula…   