The cell is probably formatted as text if yo see the formula rather
than the result. Select the cell and Format | Cells | Number (tab) and
then choose General and OK. Then double-click the formula bar as if to
edit the formula and then press Enter in order to activate the change
in format.

Your cell references will automatically adjust when you copy the
formula down - a quick way is to double-click the fill-handle. This is
the small black square in the bottom right corner of the cursor.

Hope this helps.

Pete

On Feb 1, 10:11 pm, creachter <creachter.2lc...@news.excelbanter.com>
wrote:

In answer to your first question, there are 2 likely possibilities why the
formula is displaying instead of the result.  Either the cell has been
formatted as text, or the View Formulas setting has been turned on.

If formatted as text, then select the cell, then choose "Cells" from the
FORMAT Menu.  Change the number format to "General".  Click OK.  Now,
re-enter your formula (just hit F2 then Enter).

If the format isn't the problem, then goto TOOLS, then OPTIONS, then under
the View Tab, uncheck the box labeled "Formulas".

Now, as for your second question, I don't see any reason why the cell
reference in your formula wouldn't copy correctly.  Since you're using the
Named Range "RegionMap", the only reference is to cell D2.  If the formula is
entered into cell E2, then when copied down to E3, the reference should be to
D3.  Is that not right?

HTH,
Elkar