Choose Language Hide Translation Bar
Highlighted

## 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

## 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 3

## 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

## 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.