Some thoughts ..

I'd usually calc percentage increases/decreases based on the old prices

Assuming old prices in A2 down, new prices in B2 down
Place in C2: =(B2-A2)/A2
Format C2 as percentage to taste.
Copy C2 down as far as required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
Is b1 the old or new price?

"Teethless mama" wrote:

=(B1-A1)/B1


"Richard" wrote:

Hi,

I have a list of parts that have had price increases. One column has the old
price the other has the new price. I need to show the difference, whether it
is positive or negative and the percentage of the increase or decrease. The
difference is not a problem. The problem lies in calculating the percentage.
I don't how to do that. Can someone tell me?

Thanks,
Richard