So annoyed I can't find a simple answer to this simple question!
I'm using OpenOffice Calc. I want a formula which will detect if the cell is blank, and if it is to replace it with the contents in the cell above it.
I guess the best way to do this is create a new blank column, put formulae in there. Then copy the formula results and paste into original column as plain text.
Column A : Column B (formula column)
Joe Joe
Bloggs Bloggs
Mack Mack
Mack
Mack
Peter Peter
John John
John
Joe Joe
Something like this:
=IF(A2="",A1)
or =IF(ISBLANK(A2);A1)
Can't seem to get formulae to work and I only get an error (err:508 / err:509).