cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

How do I look for a blank cell with an if statement?

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 1Column 2Column 3
122
2
3
433
52

2

1 ACCEPTED SOLUTION

Accepted Solutions
ron_horne
Super User (Alumni)

Re: How do I look for a blank cell with an if statement?

hi stephaniejlucas

try ismissing (:column)

View solution in original post

4 REPLIES 4
ron_horne
Super User (Alumni)

Re: How do I look for a blank cell with an if statement?

hi stephaniejlucas

try ismissing (:column)

Re: How do I look for a blank cell with an if statement?

Thank you!

Kevin_Anderson
Level VI

Re: How do I look for a blank cell with an if statement?

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 == "".

Re: How do I look for a blank cell with an if statement?

Thank you!