MrExcel Publishing
Your One Stop for Excel Tips & Solutions

% 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


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