IF Formula using 'text' as a condition


Board Regular
Hi there,

Using the IF function, I'm simply looking to return the contents of a cell only if it has text in it.

I thought the Logical test might be; IF A1 = " "

This is clearly wrong. Can anyone assist please?

Also, if the cell is blank (False)then it currently returns a 'zero'. I would like it to leave the cell blank.



Some videos you may like

This Week's Hot Topics