BookmarkSubscribeSubscribe to RSS Feed

Community Trekker

Joined:

Mar 7, 2017

## Formula Problem

I am having problem to set it up in JMP formula editor. I hvae 6 columns A1, A2,A3,A4,A5 and A6. Each column has 10000 rows. Now I have to find out for each row if any 6 cells is greater equal to 43 and smaller equal to 63. It that is true give me 1 else give me 0. And I want to have this 1 and 0 results in a new column with 10000 rows. Any body have any experience or idea how can I do this in JMP 11 formula editor. Any help will greatly be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Joined:

Jun 22, 2012

Solution

## Re: Formula Problem

I think this formula will do what you want

``````If(
43 <= A1 <= 63 |
43 <= A2 <= 63 |
43 <= A3 <= 63 |
43 <= A4 <= 63 |
43 <= A5 <= 63 |
43 <= A6 <= 63 ,1,0
)``````
Jim
3 REPLIES

Super User

Joined:

Jun 22, 2012

Solution

## Re: Formula Problem

I think this formula will do what you want

``````If(
43 <= A1 <= 63 |
43 <= A2 <= 63 |
43 <= A3 <= 63 |
43 <= A4 <= 63 |
43 <= A5 <= 63 |
43 <= A6 <= 63 ,1,0
)``````
Jim

Community Trekker

Joined:

Mar 7, 2017

## Re: Formula Problem

Thanks a lot Jim. If you have some time sometime could you pls give the instruction (steps) how can I write this  in Formula editor. I am not able to get multiple comparisons in one If statement. I have JMP 11 and am new to JMP. Thanks a lot for your help.

Super User

Joined:

Jun 22, 2012

## Re: Formula Problem

1. create your new column

2. Open the formula editor for the new column

3. When the formula window is open, double click in the area outlined in red, where is says, "No formula"

4. This will open up the formula editor where you can then just paste the formula into the formula editor

5. Click outside of the area where you pasted the code, and JMP will convert the pasted in code to a graphical form of the formula

Jim