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
- :
- Writing a simple IF statement

- Start Article
- 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
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 10, 2019 8:54 AM
(313 views)

Hello- I would like to write a simple IF statement. In excel it would look like this.. IF(A1=B1,"LAST","") How do I write this in jmp? This statement will be in its own column. Sorry I am not quite understanding jmp's thought process yet. Thank you!!

Solved Go to Solution

1 ACCEPTED SOLUTION

Accepted Solutions

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

I got it..

`If( Column 1 == Column 2, "LAST", "")`

2 REPLIES 2

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

I got it..

`If( Column 1 == Column 2, "LAST", "")`

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

Re: Writing a simple IF statement

more details here: https://community.jmp.com/t5/Uncharted/If-Secrets/ba-p/39558?advanced=false&collapse_discussion=true...

Craige