syntax for multiple nested ifs

[adamgn]

hi all, im looking for the syntax for multiple nested ifs but dont find any real help. what would the syntax be for something like =IF ([answer] = "yes" AND ([Homework] = "Math" OR [Teacher] = "Absent"))

i would like to nest and OR statement after an AND statement within the same IF statement. in otherwords, if the content in column [answer] = yes AND either [homework] = "math" or [teacher] = "absent" return "help"

[ray_ux · Accepted solution]

@adamgn 
https://docs.microsoft.com/en-us/powerquery-m/operators

Operator    Description
or    Conditional logical OR
and    Conditional logical AND
not    Logical NOT

just use brackets to force the precedence as required
https://docs.microsoft.com/en-us/powerquery-m/m-spec-conditionals

if 2 > 1 then 2 else 1          // 2
if 1 = 1 then "yes" else "no"   // "yes"​