Variance calculation
MS Excel 11.0 continues to have the same problem it has had forever. For
reasons I haven't been able to work out, it occasionally returnes negative variance or some positive value that is completely wrong. Based on the formula used to calculate variance as described in the documentation, a negative value is impossible. What gives? |
|
All times are GMT +1. The time now is 03:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com