Assign value with If

Support
1

Hi,again

Well, I need a formula to do this

image

I created a Calculated field and try to use "if" in "calculation" but doesn't work, Im not good to created "if nested" :sweat_smile:

Can someone help me, please.

2

Hi @Samuel_Pineros
maybe something like:

if(${age}<=5,’EARLY CHILDHOOD’,
   if(${age}<=11,’CHILDHOOD’,
      if(${age}<=17,’ADOLESCENCE’,
         if(${age}<=28,’YOUTH’,
            if(${age}<=59,’ADULTHOOD’,’OLD AGE’)))))

lifecycle.xlsx (5.8 KB)

1 Like
3

Thank you @Grzesiek2010 , it's works !!!, but ¿it's not necessary put the intervalues in the formula?, like:

0 to 5 = EARLY CHILDHOOD
6 to 11 = CHILDHOOD
12 to 17 = ADOLESCENCE
etc...

4

No, if are using if statements like that one you can just check the higher value like I did.

5

Ok @Grzesiek2010 thank you soo much :+1: