View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default difference in percentange

Then you want:
=(E1-D1)/D1

Regards,
Fred

"Caribbrz" wrote in message
...
This is probably a very easy question....

I have the following

cell D cell E
484 526

In cell F I want to show the difference in a percentage. I currently
have
the following format
(D1-E10/D1 but it gives me a -9%....when it is actaully an
increase....what am I doing wrong?