I am trying to make a formula that if Cells A1, B1, C2, D3 = BLANK, my cell returns a blank. If they are all filled, then return them all into one cell.
Cell A10 = IF A1 = ''", "", IF B1 = "","", IF C2 = "","", IF D3 = "","", A1,B1,C2,D3
I am trying to make a formula that if Cells A1, B1, C2, D3 = BLANK, my cell returns a blank. If they are all filled, then return them all into one cell.
Cell A10 = IF A1 = ''", "", IF B1 = "","", IF C2 = "","", IF D3 = "","", A1,B1,C2,D3
Are {A1, B1, C2, D3} blank as a result of a formula or are they actually blank?
When you say you want them in one cell: do you want them separated by a comma or a newline etc.?
If things don't change they stay the same
Also what would happen if one, two or three out of the 4 cells was blank?
Each Cell is initially blank, and are manually filled in throughout a process.
I want A10 to have the other cells brough over like a newline.
I don't want
- A1, B1, C2, D3
I want:
- A1
B1
C2
D3
Try:
=IF(OR(A1="",B1="",C2="",D3=""),"",TEXTJOIN(",",,A1,B1,C2,D3))
also... remember that creating a small sample file for us to play with makes it easier for us to help you.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Here is my effort:
Formula:Please Login or Register to view this content.
Remember, cell A10 will need to be formatted as wrap text.
Ah yes... I missed that:
=IF(OR(A1="",B1="",C2="",D3=""),"",TEXTJOIN(CHAR(10),,A1,B1,C2,D3))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks