struggling with else if function in power query

[LTi]

Good evening,

I've tried to create a test logic using an if then function. It is about the evaluation of the Value column. If this column contains the percentage value less than 50%, then "critical" should be output, if this value is greater than 50% but less than or equal to 70%, then "slightly critical" should be output otherwise OK. Unfortunately, the formula below does not work. Who can take a look at this and have a solution suggestion for me? Thanks in advance.

= if[#"value %"] <= 0,50 then "critical" else
if[#"value %"] > 0,50 and <=0,75 then "slightly critical" else "OK"

[hashtag_pete]

Hi LTi, 
you can paste this formular

= Table.AddColumn(#"ChangeTo PreviousStep", "Custom", each if [#"value %"] <= 0.5 then "critical" else if [#"value %"] <= 0.7 then "slightly critical" else "OK")

Best

hashtag_pete

PS: if successfull, please give kudos and mark as solution

[ppm1]

Please try this instead.

= if[#"value %"] <= 0,50 then "critical" else
if [#"value %"] > 0,50 and [#"value %"] <= 0,75 then "slightly critical" else "OK"

Pat

[LTi]

Hi Pat, thank you for your assistance but it still doesn't work.

Error: expected token: 'then'