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 resultin...
