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
- :
- Is there a way to put different forumlas in cells in the same column in JMP

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

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 20, 2017 11:56 AM
(4485 views)

Hi,

In Excel I can put different formula/calculations in different cells in the same column. It is very useful for a specific type of calculation I do regularly. Is there a way I could do this in JMP? Thanks.

Kind regards,

Elaina

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Elania,

What Bill said is correct, but not the complete story. Many times, I effectively have different equasions for different rows in JMP. However, using JMP's terminology, they are all contained within one formula. The following is a completly ligetament formula, with different equasions being used on 2 different cells.

```
If( Row() == 1, :x + :Y );
If( Row() == 2, :x - :Y );
```

Typically, one does not use the row number as the flag for what formula to use, but rather something like:

```
If( :Sex=="F", :x + :Y );
If( :Sex=="M", :x - :Y );
```

Also remember, that a formula in JMP can be of any level of complexity. You may find that your data is layed out in a less than convenient format, and changing it's structure might make it easier to use JMP formulas, or you may be able to solve you issues with something like the examples I provided. I do know, that JMP should be able to handle any issues you have.

Jim

2 REPLIES 2

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Is there a way to put different forumlas in cells in the same column in JMP

Hi Elaina,

That is one of the major differences between JMP and Excel. JMP is column centric vs. Excel being cell centric. So adding another formula in single JMP cell is not really something you can do on a permanent basis. You can add a "temporary" formula in cell by clicking in the cell and typing the = sign to start the formula, but that will not stick once you click out of or overwrite with a column formula.

HTH

Bill

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Elania,

What Bill said is correct, but not the complete story. Many times, I effectively have different equasions for different rows in JMP. However, using JMP's terminology, they are all contained within one formula. The following is a completly ligetament formula, with different equasions being used on 2 different cells.

```
If( Row() == 1, :x + :Y );
If( Row() == 2, :x - :Y );
```

Typically, one does not use the row number as the flag for what formula to use, but rather something like:

```
If( :Sex=="F", :x + :Y );
If( :Sex=="M", :x - :Y );
```

Also remember, that a formula in JMP can be of any level of complexity. You may find that your data is layed out in a less than convenient format, and changing it's structure might make it easier to use JMP formulas, or you may be able to solve you issues with something like the examples I provided. I do know, that JMP should be able to handle any issues you have.

Jim