View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default difference in percentange

How about:

=(e1-d1)/d1



Caribbrz wrote:

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?


--

Dave Peterson