turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Formula Problem

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Mar 16, 2017 6:16 PM
(1847 views)

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.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Mar 16, 2017 7:23 PM
(3513 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Mar 16, 2017 7:23 PM
(3514 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Mar 16, 2017 8:21 PM
(1833 views)

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Mar 16, 2017 8:29 PM
(1829 views)

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