Percentage of deviance..two cells!

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

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?!
 
Hi,

Formatted as % this would show your actual to be 3.46% over budget

=(C20-C1)/C1

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Challenging the GOAL SEEK function within a bonus scheme 6
Excel repatation of Formula 8
Percentage between two given times in Excel 2
Sum every 6th cell in a row. 3
Show other cell if blank 5
Copy data of two cells into one 19
Transpose? Offset? Variable starting cell 4
Strange request: Counting cells and percentages 4

Back
Top