In the simple below, I applied this formula =MAX(A3:A11)-MIN(A3:A11) so that Excel found the highest number in the range which was 90 and then subtracted it from the lowest number it found which was 5. So, we end up with a variance of 85.
Software examples that you can easily understand and immediately apply to your own business needs.
Thursday, March 10, 2011
Variance in a Range
In the simple below, I applied this formula =MAX(A3:A11)-MIN(A3:A11) so that Excel found the highest number in the range which was 90 and then subtracted it from the lowest number it found which was 5. So, we end up with a variance of 85.
Subscribe to:
Post Comments (Atom)
Ms. Excel- Resident Excel Geek
No comments:
Post a Comment