View Single Post
  #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?!