Problem with a Concatenate IF staement

[benprelf]

Hi I was wondering if anyone could help me with this?

=IF("CreateCableEXM!D10"<>"MM",

CONCATENATE("The Cable is ",J18," ",D18," with a length of ",D20," mm which will then be terminated by ",J20," Connectors."),

IF("CreateCableEXM!D10"="MM",

CONCATENATE("The Cable is ",J18," ",D18," with a length of ",D20," mm which will then be terminated by ",J20," Connectors."," The Fibre Size Core/Cladding is ",J22,".")))

I want to be able to show the first IF statement up to the word "Connectors" if the cell "CreateCable!D10" does not equal "MM" . If the cell "CreateCable!D10" equals "MM" then I would like the second IF statement to show.
The code shows the first if statement but not the second, with no error messages. I already have "MM" selected.

 

[Special-K99]

Try removing the double quotes from around all instances of CreateCable!D10

You dont even need the second IF

 

[benprelf]

Haha I'm so stupid, that works perfect thanks!

 

[Special-K99]

You could even shorten that to

=CONCATENATE("The Cable is ",J18," ",D18," with a length of ",D20," mm which will then be terminated by ",J20," Connectors")
&IF(CreateCableEXM!D10<>"MM",", the Fibre Size Core/Cladding is "&J22&".",".")

 

[benprelf]

Thanks again - although I needed to change the "<>" to "=" otherwise this worked the other way round .