Percentage Formula
 

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

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

Percentage Formula
 

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
=================================


"sunderland27" wrote in message
...
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?)

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

Percentage Formula
 

I would just copy the same formula down all your rows. How is your data laid
out?

"sunderland27" wrote:

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

Percentage Formula
 

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

--
Regards,
Fred


"Daniel CHEN" wrote in message
...
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
=================================


"sunderland27" wrote in message
...
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?)