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
- :
- formulas in columns

- 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
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

formulas in columns

Dec 21, 2011 5:26 AM
(1053 views)

is it possible to have different formulas for different rows in the same column? for instance, I have 4 groups of rows and in a given column, I want a different formula for each row group. if yes, how do I do that?

thanks

1 REPLY

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

formulas in columns

No, you cannot have different formulas. But you can use the *same* formula that evaluates *differently* depending on group. Use If() or Match() functions to build conditional formulas,

Example:

If(:group=="A", :X+1, :group=="B", :X+2, :group=="C", :X+3, :group=="D", :X+4, 99999)