I have a question with If statement

[Anonymous]

I am trying to write an If statements for three conditions like 

Rating =

IF((Sheet0[Likelihood to recommend])<7,"Detractors",

(Sheet0[Likelihood to recommend])>8,"Promotors",

(Sheet0[Likelihood to recommend])>6,"Passive"). 

But I get an error like 

Too many arguments were passed to the IF function. The maximum argument count for the function is 3.

Could anyone help with this 

[Anonymous · Accepted solution]

Figured out it worked with switch function

Rating = SWITCH(TRUE(),

Sheet0[Likelihood to recommend]<7,"Detractors",

Sheet0[Likelihood to recommend]>8,"Promotors",

Sheet0[Likelihood to recommend]>6,"Passive","No data")

[Anonymous]

Hi James, thanks for your help but  I still get the syntax error 

The syntax for ')' is incorrect. (DAX(IF((Sheet0[Likelihood to recommend])<7,"Detractors",if(Sheet0[Likelihood to recommend])>8,"Promotors",(Sheet0[Likelihood to recommend])>6,"Passive")))).

[Anonymous]

Rating =

IF((Sheet0[Likelihood to recommend])<7,"Detractors",

if(Sheet0[Likelihood to recommend])>8,"Promotors",

(Sheet0[Likelihood to recommend])>6,"Passive"))