Question: When nesting functions in Excel, parentheses are needed. However, in Power Query IF , why aren't when nesting functions or complex calculations inside an parentheses
When nesting functions in Excel, parentheses are needed. However, in Power Query IF why aren't when nesting functions or complex calculations inside an parentheses necessary?
Select an answer:
An IF in Power Query considers everything between Then and Else as an isolated piece.
In Power Query the Custom Column wizard guides you through building an IF statement.
In the Custom Column dialog box you input the components of the IF statement on different rows, and that's the equivalent of parentheses.
This isn't true. You do need parentheses.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
