ChatterBank1 min ago
Acknowledging empty cells in excel
1 Answers
I have the name of a person in cell A1
Cell B1 then copies this names automatically and remain blank if A1 is blank (i.e. no error message appears)
I then want cell B1 to go back to being blank if cell C1 has an entry in it
I have started the forumla for B1, but cannot figure out the latter part:
=IF(A1=0,"",A1)
Can anybody please help?
Cell B1 then copies this names automatically and remain blank if A1 is blank (i.e. no error message appears)
I then want cell B1 to go back to being blank if cell C1 has an entry in it
I have started the forumla for B1, but cannot figure out the latter part:
=IF(A1=0,"",A1)
Can anybody please help?
Answers
Only 1 answer
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.Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.