| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| Calculate % variance on previous quarters. Quarter %, etc. pivot | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
