How to work out a % variance in MS Excel

This is something we probably all use quite often.  Or at least we should but often don't really know how.  That gorgeous dress is on sale and you want to brag to everyone about the % you saved.  You're giving a staff member an increase and you want to be able to tell them the %.  You're selling lemonade on the pavement and you want to work out your profit margin.... there are a million different uses for this formula

Using the example below, I'm working out the % difference between the old and new prices.  You need to click into the cell that you would like to contain the answer and then create a formula by:

• Typing the = sign
• click on the NewPrice
• type /
• click on the OriginalPrice
• type -1
• press enter

The answer will appear as a decimal, so you can format that to display as a percentage.  

Are there other calculations you struggle with?  Leave a comment and let me know... you might be might inspiration for the next installment of MissusMck's tips.