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

[#1]

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

[#2 · Accepted solution]

hi stephaniejlucas​

try ismissing (:column)

[#3]

Thank you!

[#4]

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

[#5]

Thank you!