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

- JMP User Community
- :
- Discussions
- :
- Basic question concerning IF statements

- 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

Created:
Aug 21, 2018 6:36 AM
| Last Modified: Aug 21, 2018 6:40 AM
(3945 views)

Are the two IF formulas behaving in the exact same way or is there any difference? Which syntax should be preferred for numeric data and why?

IF Statement1

```
If( :Value > 1, 1, Empty() )
```

IF Statement2

`If( :Value > 1, 1 )`

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

If you open the formula for each of the columns in your sample data table, you will see that JMP interprets both of them as the same.

Jim

2 REPLIES 2

Highlighted

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

If you open the formula for each of the columns in your sample data table, you will see that JMP interprets both of them as the same.

Jim

Highlighted
##

Thanks. I did realize this already, but was not sure whether JMPs treat both IF statements always in the same way.

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

Re: Basic question concerning IF statements

Article Labels

There are no labels assigned to this post.