| 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!! |
| 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) | |||
Threaded Mode
