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

thanks for the info

how would i create a formula that would evaluate the percentage change from
month to month. for instance

Jan/Feb . . . . Feb/Mar . . . . . Mar/April and so on
Percentage total
(how
would i get this total to change accordingly?)

"bpeltzer" wrote:

=(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?)