Concatenating cells (with IFs and Text invloved)

[CharlotteFixedIncome]

Hi everyone - here's what I have... Essentially what I'm doing is taking two cells, D2 and E2, concatenating them but adding what each one means in between. Example can be found below. The problem is that when E2 is blank, I need it to say nothing (or " ") but it's still showing "=rate; " when D2 is blank

=CONCATENATE(IF(D2<>" ",(D2&"=Parity; ")," "),IF(E2<>" ",(E2&"=Rate; ")," "))

Any thoughts? It's really not a big deal and I'm sure there is a more straight forward way to do this but I'm just working through a quick project.

Any help is greatly appreciated!

Thanks,
CharlotteFI

 

[doubledaffy]

Try getting rid of the space between your quotes.

So that its
=CONCATENATE(IF(D2<>"",(D2&"=Parity; "),""),IF(E2<>"",(E2&"=Rate; "),""))

 

[CharlotteFixedIncome]

Beautiful. Thank you!