Understanding variable assignment

[joel_h]

Hi,
I'm new to this forum and a bit stuck, when I work with the Query Editor in Excel 2016. Editing in the advanced expression mode, which I understand is using the M query language, I get errors about Token Comma expected when I makde a custom function using the code below.

Its adding the row Result = "Hello World" that throws the error. Am I supposed to reference an existing variable (Result) in another syntax?

What I'm after here is understanding what I'm doing wrong. I haven't understood how to work with variables yet.

let IsEmptyValue = (PhoneNumberString as nullable text) as logical =>
let
    Result = if PhoneNumberString = null then "" else Text.Clean(Text.Trim(PhoneNumberString))
    Result = "Hello World"
in
    Result
in
    IsEmptyValue

Grateful for any helps from the experts here in the forum!

 

[joel_h]

I'm not sure if I can edit my own post. Adding some stuff to my post
- I've found expression statements must be separated with a comma
- As a workaround I can declare new variables in each statement. It feels a bit clunky, though.

(Of course it also makes little sense to return a string here as the return method was set to logical... )