If statement blanks, 1, and 0

[Neico]

Hi!

I'm trying to create a VarNEW with the following logic:

If Var1 and Var2 are null then VarNEW is also null. If Var1 is 1 then VarNEW is 1. If Var2 is 1 then VarNEW is 0.

Var1	Var2	VarNEW
.	.	.
.	1	0
1	.	1
1	.	1
.	.	.
.	1	0

I cannot seem to get a suitable formula working. Can you please help?

Thank you!

[atcodedog05 · Accepted solution]

Hi @Neico 

Formula

IF IsEmpty(Var1) and IsEmpty(Var2) Then Null()

Elseif Var1="1" then 1

Else 0 Endif

[atcodedog05 · Accepted solution]

Hi @Neico 

Here is a workflow for the task.

IF IsEmpty(Var1) and IsEmpty(Var2) Then Null()
Elseif Var1="1" then 1
Else 0 Endif

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu · Accepted solution]

@Neico 
Hope this is what you need.

[atcodedog05]

Happy to help 🙂 @Neico 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂