Thread: Microsoft 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Microsoft 2007

Try this:-

=((A1-B1)/A1)*100

If my comments have helped please hit Yes.

Thanks.




"christie" wrote:

What is the formula for a percent change between 2 cells?
Everything I am trying will not work with the 2007 version. I have used the
formula I know in an older version and it worked fine.
Please help