column values dependent on another column

[#1]

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! 

[#2 · Accepted 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.

[#3]

Thanks! It works.