Hi, I have two columns, and I hope the values of column 2 will depend on column 1 through a kind of Boolean control.
For example, I need the column 2 below to be automatically filled:
if Column 1>0, then Column 2 in the same row becomes filled with 3.
if Column 1<0, then Column 2 in the same row becomes filled with 0.
Thanks a lot!
Go to Solution
You can use a formula in Column 2 based on this expression:
If( :Column 1 > 0, 3, 0 )
You can copy it here, open the Formula Editor for Column 2, and paste it.
View solution in original post
Thanks! It works.
There are no labels assigned to this post.