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!