1 formula for various percentages calculations.

[mr_vic]

All,

I'm hoping that someone can help me create 1 formula to span various percentages.

I have attached a copy of an Actual vs Budget variance report. It is formated in a P/L style and details the variance as a £ value.

I want to add a % formula for various types of variances produced in the report.

In column E of the report is a very basic formula of Variance / Budget. This brings back an array of answers.

In column F is the desired % that I wish to achieve through 1 formula. I don't want to be using multiple formulas in this coulmn. I want to have the ability to just grag this formula down.

Can someone help me with this?

Appreciate all of your help!

mr_vic