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,
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.
|Column 1||Column 2||Column 3|
Solved! Go to Solution.
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 == "".