How to display negative (-) values?

Hi All,

I have this formula which calculates the % increase and decrease from previous week. I made it so that it would show everything in positive. how do i go about changing it, so that negative values show as negative?

=IF((B5>B6),""&TEXT((((B5-B6)/B5)*100),"#,0.00")&"%",""&TEXT((((B6-B5)/B5)*100),"#,0.00")&"%")

thanks a lot,
Claire

Do you mean when b6>b5?
Just change your condition to =(if(b5<>b6.....

hiya,

thanks for such a quick reply..
could you please show me where exactly i need to put the = within the formula?

apologies for sounding stupid..but i am realy lost with these formulas.

thanks
C

ur right.. silly me!
why would I need that long formula if i no longer need to make both values positive? lol.. thanks a lot. the formula you wrote is a lot easier.. and i used the conditional formatting to make the negative values in red..

thanks again

C