Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.

Choose Language Hide Translation Bar

Level V

Created: Oct 9, 2021 06:05 PM | Last Modified: Jun 9, 2023 11:01 AM (9313 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!

10 REPLIES 10

Level V

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

Thanks Ron. It's working now!