range
 

How do I get Excel 2003 to calculate range? To find mode, for example, I just
type =MODE(M4:M8). This doesn't work for range. Help!

range
 

http://en.wikipedia.org/wiki/Range_(statistics)

=MAX(M4:M8)-MIN(M4:M8)
--
Gary''s Student - gsnu200830


"SJ" wrote:

How do I get Excel 2003 to calculate range? To find mode, for example, I just
type =MODE(M4:M8). This doesn't work for range. Help!

range
 

Make sure that calculation is set to automatic.
(Tools|Options|calculation tab)

Make sure that the values in M4:M8 are really numbers--not text.

For just 5 cells, I'd reformat the cells as Number (or anything but text). Then
reenter each value.

(If you've retrieved the values from a web page, you may be including those HTML
non-breaking spaces. And then the values won't be real numbers.)

SJ wrote:

How do I get Excel 2003 to calculate range? To find mode, for example, I just
type =MODE(M4:M8). This doesn't work for range. Help!

--

Dave Peterson