LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default 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?!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate percentage of cells that have any value JLeck Excel Discussion (Misc queries) 8 April 9th 23 12:47 PM
how do I get the percentage of a group of cells cancir Excel Worksheet Functions 1 August 20th 08 08:37 PM
Calculating percentage of Shaded Cells in a row BrettPotts Excel Worksheet Functions 1 March 28th 08 09:33 AM
Percentage of filled cells Carla Bradley Excel Worksheet Functions 1 January 7th 05 05:31 PM
calculate percentage of two cells Suzie Excel Worksheet Functions 4 December 3rd 04 05:27 PM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"