This is not an obvious one but I was aksed how can I show a percentage CHANGE between two values,
Sales in 2009 were 75K and by 2010 had risen to 125K what is the % change ?
The Formula you can use is as below:
Thus returning a value of 67%
nice one !!!