cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
Choose Language Hide Translation Bar
learning_JSL
learning_JSL
Level IV

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

Created: Oct 9, 2021 06:05 PM  |  Last Modified: Jun 9, 2023 11:01 AM (5815 views)

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!

 

0 Kudos
10 REPLIES 10
learning_JSL
learning_JSL
Level IV

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

Oct 10, 2021 09:20 AM (738 views)  |  Posted in reply to message from ron_horne 10-09-2021

Thanks Ron.  It's working now!  

Recommended Articles