Run multiple function under 1 IF statement

[ilcaa]

I am interested in running several functions on a text value under the same IF statement, what is the proper syntax?

• listing them on top of each other doesnt work,
• adding commas between them doesnt work
• using the AND between them doesnt work..

any suggestions? thanks

if [Type] = "BILLPAY" then
Text.RemoveRange([Description],0,28)
Text.RemoveRange([Description],6,Text.Length([Description]) )
else null

 

[AliGW]

Not clear - please attach a sample workbook.

 

[ilcaa]

if you notice in the example, there are 2 functions that removes 2 ranges...(it might not work but that doesnt matter)... my question is basic..

can you use multiple functions within a IF statement, if so what is the proper syntax to connect the 2 or more functions

 

[AliGW]

my question is basic..

It may be basic, but it is not clear.

Have a look here: https://www.myonlinetraininghub.com/power-query-if-statements