Obtaining a positive variance %
 

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!!

Obtaining a positive variance %
 

hi

=(a1/b1)-1

HTH
Regards from Brazil
Marcelo

"Bartman0609" escreveu:

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!!

Obtaining a positive variance %
 

try this

=ABS(1-(A1/B1))


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=553662

Obtaining a positive variance %
 

Great, thank you. I knew it had to be something simple.

Marcelo wrote:
hi

=(a1/b1)-1

HTH
Regards from Brazil
Marcelo

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!!