| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage of deviance..two cells!
Hi - total brain freeze.
If I have two cells, say cells C1 and C20 - and in C1 is a projected output figure, for example 19,000 and in C20 is the eventual action output which was 19,568 - how would I go about popping in a formula to C21 to show the difference in percent between the forecast amount and the actual figure?! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage of deviance..two cells!
Try this:
=(C20-C1)/C1 Format the cell as percentage. Hope this helps. Pete On Oct 3, 1:21*pm, GD wrote: Hi - total brain freeze. If I have two cells, say cells C1 and C20 - and in C1 is a projected output figure, for example 19,000 and in C20 is the eventual action output which was 19,568 - how would I go about popping in a formula to C21 to show the difference in percent between the forecast amount and the actual figure?! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage of deviance..two cells!
Hi,
Formatted as % this would show your actual to be 3.46% over budget =(C20-C1)/C1 Mike "GD" wrote: Hi - total brain freeze. If I have two cells, say cells C1 and C20 - and in C1 is a projected output figure, for example 19,000 and in C20 is the eventual action output which was 19,568 - how would I go about popping in a formula to C21 to show the difference in percent between the forecast amount and the actual figure?! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage of deviance..two cells!
Many thanks to you both
"GD" wrote: Hi - total brain freeze. If I have two cells, say cells C1 and C20 - and in C1 is a projected output figure, for example 19,000 and in C20 is the eventual action output which was 19,568 - how would I go about popping in a formula to C21 to show the difference in percent between the forecast amount and the actual figure?! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate percentage of cells that have any value | Excel Discussion (Misc queries) | |||
| how do I get the percentage of a group of cells | Excel Worksheet Functions | |||
| Calculating percentage of Shaded Cells in a row | Excel Worksheet Functions | |||
| Percentage of filled cells | Excel Worksheet Functions | |||
| calculate percentage of two cells | Excel Worksheet Functions | |||
Linear Mode
