nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Formula Problem

quest74

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.

Accepted answers

txnelson

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
)

All comments

txnelson

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
)

quest74

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

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