Percentage Formula

S

sunderland27

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?)
 
B

bpeltzer

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

Daniel CHEN

Suppose you have A1 = 715, B1 = 750, in C1 (difference) type the following
formula:

=TEXT(B1/A1-1,"0.00%").

You result will be 4.90%.


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Downloand
=================================
 
S

sunderland27

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?)
 
F

Fred Smith

There's no reason I can see to use a TEXT function, because this leaves the
result unusable in future formulas.

Just use =b1/a1-1, and format as Percent
 
Top