Donate SIGN UP

Excel - text in cells, blank, IF Function

Avatar Image
funkylad20 | 15:21 Wed 23rd Sep 2009 | Computers
1 Answers
OK, I'm doing another spreadsheet!
I have a cell with names in (A1)
I need to next cell to that (A2) to copy the previous cell when the name is entered
If cell A1 is empty, how do I make sure cell A2 is too? Currently returning a value of '0'...

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Question Author
OK, sussed it! IGNORE ME! Sorry...don't know how to delete a question?!

ANSWER: =IF(A1=0,"",A1)

Only 1 answerrss feed

Related Questions