Subscribe Bookmark RSS Feed

Formula Problem

quest74

New Contributor

Joined:

Mar 7, 2017

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
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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
quest74

New Contributor

Joined:

Mar 7, 2017

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.

txnelson

Super User

Joined:

Jun 22, 2012

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