Quizzes & Puzzles4 mins 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
Latest Posts
Quizzes & Puzzles4 mins ago
Are The West In The Grip Of The Woke...
News8 mins ago
Offers & Competitions21 mins ago
News23 mins ago
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.