cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
learning_JSL
Level IV

need jsl formula to account for empty cell in conditional if statement

Hi - I am new to jsl scripting and am trying to construct a jsl statement as follows: 

if column A is empty, column C = empty,

else if column A < 500 and column B = 200, column C = 0,

else if column A>500, column C = 1.

How would I frame a jsl formula to do this?  Thanks!

 

10 REPLIES 10
learning_JSL
Level IV

Re: need jsl formula to account for empty cell in conditional if statement

Thanks Ron.  It's working now!