Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Error for if statement

Hi Guys,
So I'm fairly new to this and would like some help over here.
For my dataset I created a column Age with randbetween function and values from 10 to 28. So this column is formed correctly. Now I wanted to create another column and divide these ages into groups like 10-12 should be kids, 13-19 should be teens, and rest should be adults.
Normally I would create a conditional column but the section doesnt show the column Age and I'm guessing thats because I used the randbetween function which is ok so I tried to do it by creating a new column by 

Age group = IF('Sheet1 (2)'[Age]>=10,'Sheet1 (2)'[Age]<=12,"Kids") & IF('Sheet1 (2)'[Age]>12,'Sheet1 (2)'[Age]<=19,"Teens")& IF('Sheet1 (2)'[Age]>=20,"Adults")
Still getting some errors.

Any help will be appreciated!
TIA.
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Turns out if and, if and and if works perfectly

     

    Age group = IF(AND('Sheet1 (2)'[Age]>=10,'Sheet1 (2)'[Age]<=12),"Kids") & IF(AND('Sheet1 (2)'[Age]>12,'Sheet1 (2)'[Age]<=19),"Teens")& IF('Sheet1 (2)'[Age]>=20,"Adults")

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Turns out if and, if and and if works perfectly

     

    Age group = IF(AND('Sheet1 (2)'[Age]>=10,'Sheet1 (2)'[Age]<=12),"Kids") & IF(AND('Sheet1 (2)'[Age]>12,'Sheet1 (2)'[Age]<=19),"Teens")& IF('Sheet1 (2)'[Age]>=20,"Adults")