Obtaining a positive variance %

  • Thread starter Thread starter Bartman0609
  • Start date Start date
B

Bartman0609

I am arriving at a variance by "=1-(A1/B1)" which gives a negative number (ie:
$9.43/$6.00=-57%). When I remove the "1-", it makes the number 157%.
How do i get this number to be just 57% (the true positive variance)?
This is probably very simple but I'm missing it.
Thanks!!
 

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

EXCEL FORMULA 2
Excel Formula and Variance Analysis 0
Variance Analysis and Excel 1
resource lookup Macro 5
% Variance 5
how do i display a variance in all positive numbers? 2
How do I work with variances when there is a negative number? 3
Date Calc in hours 6

Back
Top