it doesn't work. it doesn't see it as a formula. just as text. i just copy
and paste it and all it does is to display it as text, just as i copy it.
maybe it's a small problem, but it does'nt work.
and something i forgot to say is that if in a1 i have 0, and another number
in b1, i wont to see 0%

thanks allot

"MartinW" a scris:

Hi Pui,

One way, put this in C and drag down.

=ROUND(IF(A1<B1,A1/B1*100,-B1/A1*100),0)

and format as custom 0"%"

HTH
Martin



"puiuluipui" wrote in message
...
hi, i have a small problem..
in cell a1 and b1 i have some numbers, and i want in c1 to view the
diferences between a1 and b1 in percentage. but i want to have the
percentage
to be negative or positive.
example 1
a1 b1 c1
25 142 18%

example 2
a1 b1 c1
142 25 -18%



i hope i make the example the right way, but i want the diferences in
percentage.


thank you!!