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

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

stephaniejlucas — Thu, 05 Nov 2015 17:09:42 GMT

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

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

ron_horne — Thu, 05 Nov 2015 18:01:00 GMT

hi stephaniejlucas

try ismissing (:column)

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

Kevin_Anderson — Thu, 05 Nov 2015 20:04:49 GMT

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?

stephaniejlucas — Fri, 06 Nov 2015 08:56:30 GMT

Thank you!

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

stephaniejlucas — Fri, 06 Nov 2015 08:57:08 GMT

Thank you!