concatenate question with negative numbers

[johnny52]

Hi ,

my question ...I have 2 numbers in 2 different cells...one is a negative number.When I use the concatenate formula the result is as follows
cell a1 = 7 cell b1 = -9

=concatenate(a1," - ",b1) the result in the cell looks like 7 - -9

can I write a concatenate formula to put the negative number with parenthesis...so it would look like this 7 - (9) all in one cell ?


Thanks everybody

 

[pgc01]

Hi

Is the negative number always the second one?

 

[Lewiy]

Maybe something like this:

=IF(A1<0,"("&ABS(A1)&")",A1)&"-"&IF(B1<0,"("&ABS(B1)&")",B1)

 

[Boller]

If A1 is always positive and B1 is always negative :-

=A1 & TEXT(-B1,"-(#,###)")

or

=A1 & "-(" & -B1 & ")"

 

[barry houdini]

Are you just dealing with integers?

Try

=TEXT(A1,"0;(0);0")&"-"&TEXT(B1,"0;(0);0")

 

[johnny52]

=IF(A1<0,"("&ABS(A1)&")",A1)&"-"&IF(B1<0,"("&ABS(B1)&")",B1)

wow thanks everybody for the great answers this one worked