I want -452 into a formula that shows (452 down)

[Jeffreyxx01]

Hello everyone,

I hope the titles made sense because I do not know how to explain it.
So what I would like is to get my formula to not show the minus sign into the bracket.

PPPP	OOOO	XXXX	ZZZZ
-452	-184	-6	20	(-452 down on last week)
27	-47	-38	11	(27 up on last week)
-17	-38	-72	12	(-17 down on last week)
-26	-9	12	27	(-26 down on last week)
32	55	8	-9	(32 up on last week)

<tbody>
[TD="colspan: 2"]Movements
[/TD]

</tbody>

The formula I currently use in the 5th column is as follow:

=IF(D11>D3,CONCATENATE("(",TEXT(I11,0)," up on last week",")"),IF(D11=D3,CONCATENATE("(","flat on last week",")"),IF(D11<D3,CONCATENATE("(",TEXT(I11,0)," down on last week",")")," ")))

if Anyone know a way to get rid of the minus sign into my formula, it would be great.

Thank you a lot.

Jeffrey

 

[Jeffreyxx01]

I actually found myself the answer.
I used the =ABS formula into the cell.

:D :D