How to Use "IF" and "E" Function in Power Query

[Anonymous]

I would like some help on how to use the excel “IF” and “E” functions in the power query. You would need to use the two functions together. Thanks

[AlexisOlson]

What's the Excel expression you are trying to replicate?

[Anonymous]

The expression would be this

"=SE([@[Weight-Hub Factor]]<=5;"0.00 to 5";
IF(E([@[Weight-Hub Factor]]>5;[@[Weight-Hub Factor]]<=10);"5.01 to 10";
IF(E([@[Weight-Hub Factor]]>10;[@[Weight-Hub Factor]]<=15);"10.01 to 15";
IF(E([@[Weight-Hub Factor]]>15;[@[Weight-Hub Factor]]<=20);"15.01 to 20";
IF(E([@[Weight-Hub Factor]]>20;[@[Weight-Hub Factor]]<=25);"20.01 to 25";
IF(E([@[Weight-Hub Factor]]>25;[@[Weight-Hub Factor]]<=30);"25.01 to 30";
IF(E([@[Weight-Hub Factor]]>30;[@[Weight-Hub Factor]]<=35);"30.01 to 35";
IF(E([@[Weight-Hub Factor]]>35;[@[Weight-Hub Factor]]<=40);"35.01 to 40";
IF(E([@[Weight-Hub Factor]]>40;[@[Weight-Hub Factor]]<=45);"40.01 to 45";"

[v-kelly-msft]

Hi @Anonymous ,

In power query,you could use "if" statement,such as if ..then..else or if ..then if ..else..else,check below reference:

https://gorilla.bi/power-query/if-function-in-power-query/

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[AlexisOlson]

I've never seen functions SE and E in Excel and they aren't in the documented list of Excel functions. What do they mean?