Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
% diff calculation
Posted by Fred Lesar on January 17, 2001 2:42 AM
Hi, I am a new comer to excel, please can you help me with the following calculation.
How do i calculate the % diff between two sets of figures e.g between actual expenses for 1999 versus actual for 2000?
'99 '00
$20 £30 = ? difference either + or negative
Thank you
Fred
| Check out our Excel Resources
|
 |
 |
Re: % diff calculation
Posted by Dave Hawley on January 17, 2001 2:51 AM
Hi Fred
If your 2 values are in cells A1 & B1 then use:
=(A1-B1)/100
and format you cell as a percentage if you wish.
Dave
OzGrid Business Applications
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.