Subscribe Bookmark RSS Feed

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

stephaniejlucas

Community Trekker

Joined:

Feb 24, 2015

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
Solution

hi stephaniejlucas

try ismissing (:column)

4 REPLIES
Solution

hi stephaniejlucas

try ismissing (:column)

stephaniejlucas

Community Trekker

Joined:

Feb 24, 2015

Thank you!

kevin_c_anderso

Community Trekker

Joined:

Jun 5, 2014

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

stephaniejlucas

Community Trekker

Joined:

Feb 24, 2015

Thank you!