This worked. Thanks.

My second question is: I am using this formula to calculate the variance between two columns (column E - column F).

=IF(OR(E10=0,F10=0),100,E10/F10)

I want my variance to show as a percentage and if I use this formula it works fine if column F is zero because then it shows 100, but if column E is zero I get an error even though it's supposed to show -100.