cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
EFarrell
Level II

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

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
txnelson
Super User

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

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

View solution in original post

2 REPLIES 2

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

txnelson
Super User

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

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