I have two columns of formula's that I then concatenate the results into a third formula. Is there any way to combine these formula's into one?
Formula 1: =IF(G6="","",IF(F6="",C5,F6))
Formula 2: =IF(G6="","",IF(E6="",B5,E6))
Formula 3: =CONCATENATE(B6," ",C6)
Thank you to anyone that can help me out.
Bookmarks