% Difference Formula

[AndrewKent]

If I wanted to find the % difference with two numbers I can do this manually...

=6.9/4.9-100%

...is a 40.82% difference.

However is there a formula that will work out a % difference between two figures without having to do this manually?

Cheers,

Andy

 

[NBVC]

You mean?

=A1/A2-100% where A1 and A2 house the numbers to evaluate?

 

[AndrewKent]

yeah i just wondered if there was an actual formula for that As we have =SUM(A1:A2) will do the same job as =A1+A2

Andy

 

[mortgageman]

There is no built in function, (I assume that's what you meant) but here is a UDF:


Function percentchange(newvar As Double, oldvar As Double) As Double
'formula: (new-old)/old
percentchange = (newvar - oldvar) / oldvar
End Function

Gene, "The Mortgage Man", Klein

 

[AndrewKent]

Thanks,

I was foolishly looking for a formula along the lines of =DIFFERENCE(A1,A2) but there was nothing,

Thanks anyway,

Andy