Hi, I have 3 columns of data and I'm trying to put together a formula using the IF function and is blank but I'm not getting results in 2013 excel. I want to concatenate cells a3 and b3 if cell c3 is blank, if cell c3 is not blank i want to concatenate cells a3 and c3 into column d.
I've tried IF(Isblank(c3),concatenate(a3,b3),concatenate(a3,c3)) My2013 is not highlighting the part of the formula that is the problem (why would that be too?) so I can't troubleshoot it by point.
Thanks.
Bookmarks