turn on suggestions

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
- :
- How do I look for a blank cell with an if statement?

Topic Options

- 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

Nov 5, 2015 9:09 AM
(7627 views)

Hi,

Does anyone know if there's a way of assigning a blank cell in an if statement?

I want to make a column with a formula that either uses the value from column 2, if one exists, or the value from column 1 if the cell in column 2 is blank. I tried to achieve this using the following formula for column 3:

If( :Column 2 > 0,

:Column 2,

:Column 1

)

but if column 2 doesn't contain a number then the resulting cell in column 3 is blank (see table below). Is there any way around this without assigning the missing values in column 2 as a number?

I'd be grateful of any suggestions.

Steph

Column 1 | Column 2 | Column 3 |

1 | 2 | 2 |

2 | ||

3 | ||

4 | 3 | 3 |

5 | 2 | 2 |

1 ACCEPTED SOLUTION

Accepted Solutions

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

Nov 5, 2015 10:01 AM
(13470 views)

4 REPLIES

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

Nov 5, 2015 10:01 AM
(13471 views)

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

Nov 6, 2015 12:56 AM
(7390 views)

Thank you!

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

Nov 5, 2015 12:04 PM
(7390 views)

And if you ever need to find one, it can be handy to remember that a missing character value can be thought of as a string of zero length. In other words, where :CharColumn == "".

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

Nov 6, 2015 12:57 AM
(7390 views)

Thank you!