cancel
Showing results for
Did you mean:
Frequent Visitor

## Multiple IF

Hola;

Necesito segmentar datos en 4 o 5 categorías diferentes (<10, >10, >15, >30), doy un ejemplo sencillo:

A            5                    <10

B            29                   >15

C           13                    >10

D           55                   >30

E            14                   >10

Actualmente uso:

Pero necesito realizar más condiciones y no me lo permite.
Gracias
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Multiple IF

You could use nested IF statements, but I would use a SWITCH(TRUE()...) statement.

Proud to be a Datanaut!

2 REPLIES 2
Super User

## Re: Multiple IF

You could use nested IF statements, but I would use a SWITCH(TRUE()...) statement.

Proud to be a Datanaut!

Highlighted
Community Support Team

## Re: Multiple IF

Hi @shinjit

Try below formula:

```Column =
IF (
"<10",
IF (
">10",
IF ( Table3[Edad] > 15 && Table3[Edad] < 30, ">15", ">30" )
)
)
```

or

```Column 2 =
SWITCH (
TRUE (),