| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference in percentange
This is probably a very easy question....
I have the following cell D cell E 484 526 In cell F I want to show the difference in a percentage. I currently have the following format (D1-E10/D1 but it gives me a -9%....when it is actaully an increase....what am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
difference in percentange
Then you want:
=(E1-D1)/D1 Regards, Fred "Caribbrz" wrote in message ... This is probably a very easy question.... I have the following cell D cell E 484 526 In cell F I want to show the difference in a percentage. I currently have the following format (D1-E10/D1 but it gives me a -9%....when it is actaully an increase....what am I doing wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
difference in percentange
How about:
=(e1-d1)/d1 Caribbrz wrote: This is probably a very easy question.... I have the following cell D cell E 484 526 In cell F I want to show the difference in a percentage. I currently have the following format (D1-E10/D1 but it gives me a -9%....when it is actaully an increase....what am I doing wrong? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the Difference Between <30 and .<30 | Excel Discussion (Misc queries) | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| what is the difference between $D$13 and $D13 | Excel Worksheet Functions | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
| up down bar value (difference) | Charts and Charting in Excel | |||
Linear Mode
