User Community
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 will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 (6515 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 (830 views)  |  Posted in reply to message from ron_horne 10-09-2021

Thanks Ron.  It's working now!  

Recommended Articles