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
|