Take the 2-minute tour ×

Envision two rows, one up top and one below it. The cell up top is blank but the one below has 9/24/12. How can I create a function that will make the top one copy the value of the cell below it if it is empty?

P.S. I'm not great with scripts.

share|improve this question

1 Answer 1

Assuming that cell A1 is the top row and A2 is the next row, put the following formula in cell A1.

=if(A2="", "New Value", A2)
share|improve this answer

Your Answer


