Formatting formula multiple values in column

[carlosbriceo (Carlos)]

Hello community! I’m trying to set up a formula but I always have an error:

This are the values:

IF(AND({Products}>=10,{Clients}>=20,{Sales}>=1000),“Nivel 1”,“Nivel 0”)
IF(AND({Products}>=15,{Clients}>=30,{Sales}>=5000),"Nivel 2”,”Nivel 1”)
IF(AND({Products}>=20,{Clients}>=40,{Sales}>=30000),"Nivel 3”,”Nivel 2”)

I tried to set up this way but does not work:

IF(AND({Products}>=10,{Clients}>=20,{Sales}>=1000),“Nivel 1”,“Nivel 0”, IF(AND({Products}>=15,{Clients}>=30,{Sales}>=5000),"Nivel 2”,”Nivel 1”, IF(AND({Products}>=20,{Clients}>=40,{Sales}>=30000),"Nivel 3”,”Nivel 2”)))

I would like to understand this error.

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi @carlosbriceo,

The error comes from the fact that you’re having 4 arguments in your IF statement, when there should be only 3.

The correct syntax is:

IF(Condition,If_True,If_False)

Your syntax is:

IF(Condition,If_True,If_False,EmbeddedIfStatement)

[MHaigh (Matthew Haigh)]

Try this…
IF( AND({products}>=20,{clients}>=40,{sales}>=30000),“Nivel3”,IF( AND({products}>=15,{clients}>=30,{sales}>=5000),“Nivel 2”,IF( AND({products}>=10,{clients}>=20,{sales}>=1000),“Nivel 1”,“Nivel0”)))

This is the same just spaced out to make more readable…
IF( AND({products}>=20,{clients}>=40,{sales}>=30000),“Nivel3”,
** IF( AND({products}>=15,{clients}>=30,{sales}>=5000),“Nivel 2”,**
** IF( AND({products}>=10,{clients}>=20,{sales}>=1000),“Nivel 1”, “Nivel0”**
)))