Can you use concatenate with an IF statement in excel?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
5 views
1 Answers
Dr. Md Rushad Rahman
এমবিবিএস(আরপিএমসি)
,
পিজিটি(মেডিসিন)
Yes. Below is an example of a formula I put together using nested IF statements for a spreadsheet where the output depended on 2 input cells. =IF(ISBLANK(B9),IF(ISBLANK(B10),"",B10),IF(ISBLANK(B10),B9,CONCATENATE(B9," & ",B10))). Result: if B9 and B10 are blank the output cell will show nothing; if B9 = "word" and B10 is blank; output = "word"; if B9 is blank and B10 = "text"; output = "text"; if B9 = "word" and B10 = "text"; output = "word & text".
5 views
Answered