In Excel 2013, if I use a named range as the argument for the N function in a formula, the result is not what I expect.
For example, if I name a range (say, $A$2:$A$11 as "Volume"), and fill another range (say, $B$2:$B$11) with the formula"=N(Volume)", I would expect cells in Column B to show the result of the N function for their adjacent cells in Column A.
Instead, *all* cells in Column B show the result of the N function for only the *first* cell in Column A (i.e. $A$2).
Some functions in Excel appear to work as I expect when I use named ranges as their arguments, but the N function (and perhaps others?) do not.
Do I misunderstand the way Excel uses named ranges; is my formula syntax incorrect for the results I expect; is the N function not returning valid results; or is there some other explanation?