Double IF formula - Help!

[magixx]

Hi

I have been racking my brains on how to do this, I'm not even sure if it's an IF formula I need.

I've attached a spreadsheet and its a basic report that is comparing this year with last year's figures. I have a column for 2012, another for 2011, a variance column and a percentage variance column.

The problem is the formula in the variance percentage column. The formula is fine when there are figures shown in both 2012 and 2011 but when there is a zero in either, the #DIV/0! shows up.

Now, I have put a formula in to say that if the number is zero in 2012 column then put in '0'. It works. However, if there is a zero in the 2011 column because my IF formula doesn't include a condition for this it will show #DIV/0!.

With me so far? Sorry, I hope I'm explaining this well..

So I'm guessing I need to add another IF formula but I have tried various things including adding two IF's together but none of them work.

I've given an example in the spreadsheet attached. I would like cell I14 to show '0%' . If anyone can shed some light on this that would be great. Thank you