View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default Percentage Formula

=(750-715)/715
If your table begings in A1, then in C2, =(b2-a2)/a2. Format the result as
a percent.

"sunderland27" wrote:

What would be the formula if i wanted to find the percentage difference
between to figures. for instance

Jan Feb Diff
715 750 (what would be the formula to find the
difference?)