Calculating variance.

  • Thread starter Thread starter Andrew Mackenzie
  • Start date Start date
A

Andrew Mackenzie

I regularly have to calculate the percentage variance between two cells and
type in the formula: =(A2-A1)/A1. Is there someway of doing this without
having to rewrite the formula each time. A simple macro is not the answer
because the cells are not necessarily adjacent to each other.

I feel that this must be a common request so I apologise if this is a
frequently answered question.

Thanks for any help.
 
Hi!

If there is no guaranteed pattern to the comparisons then I suspect th
programmed cure might well be worse than the disease.

However, =A2/A1-1 has fewer keystrokes than your formula.

Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CALCULATING VARIANCE 5
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
How do I calculate variance percetage if figures are negative 5
Formula for calculating Variance 2
formula help 6
Time calculations 3
Reference a cell for a formula 3
Pivot Table Subtotals/Variance Analysis 1

Back
Top