Formula help, please

[Mel Smith]

I am trying to write a formula so that if cell CP12=0, then display 0, otherwise if cell CP12 = (say) 2 then display 2 AND the value of cell CP 13.
For example: CP 12 = 3 and CP 13 = 6 display in cell DB 4: 3(6)

Many thanks for your help.

Mel

 

[Mel Smith]

I've solved it for myself
=IF(CP12=0,0,(CP12)&"("&(CP13)&")")

Mel

 

[Peter_SSs]

I've solved it for myself
=IF(CP12=0,0,(CP12)&"("&(CP13)&")")

You could also do it with quite a few less parentheses

=IF(CP12=0,0,CP12&"("&CP13&")")

 

[Mel Smith]

Thank you, Peter.

Mel