Forum Discussion
Solved
IF Statement Help
Hi Everyone: I am creating a new column and I want the formula to give me blank if the "Result" column has null on it. WHat I'm doing wrong? I have been trying to fix the "else if" but it's prett...
- Power Query is Case sensitive. Give all IF in small i.e. if.
Use first query but give if in small.
These are different formulas that I have been try to use but always get the "Token Eof expected".
IF [Result] =null then null else if [Result]>=3 then 1 else 0
if ([Result] =null, "",if([Result]>=3,1,0))
if [Result] = "" then "" else [Result]>=3 then 1 else 0
Any tips?