Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
formula percentage problem | New Users to Excel | |||
How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
Percentage Formula | Excel Worksheet Functions |