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. ...
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")

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")