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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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 (3663 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 (430 views)  |  Posted in reply to message from ron_horne 10-09-2021

Thanks Ron.  It's working now!