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

- JMP User Community
- :
- Discussions
- :
- Re: column values dependent on another column

- 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

Feb 3, 2020 8:13 AM
(456 views)

Hi, I have two columns, and I hope the values of column 2 will depend on column 1 through a kind of Boolean control.

For example, I need the column 2 below to be automatically filled:

if Column 1>0, then Column 2 in the same row becomes filled with 3.

if Column 1<0, then Column 2 in the same row becomes filled with 0.

Thanks a lot!

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

You can use a formula in Column 2 based on this expression:

`If( :Column 1 > 0, 3, 0 )`

You can copy it here, open the Formula Editor for Column 2, and paste it.

Learn it once, use it forever!

2 REPLIES 2

Highlighted

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

You can use a formula in Column 2 based on this expression:

`If( :Column 1 > 0, 3, 0 )`

You can copy it here, open the Formula Editor for Column 2, and paste it.

Learn it once, use it forever!

Highlighted
##

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

Re: column values dependent on another column

Thanks! It works.

Article Labels

There are no labels assigned to this post.