So did you check to see that Calculation was Automatic?

In article ,
LindaO wrote:

When I try to copy the formula down to other cells in the column, the answer
to the first cell shows in all other cells, even though the formula has
changed relative to the location of the copy (F2 becomes F3, etc.). I don't
even get the option to "fill" the range if I use the right mouse on the cell
selector corner. Seems strange...

"JE McGimpsey" wrote:

So what *does* happen when you copy the formula in G2 to other cells in
the column? Check to make sure Calculation is set to Automatic
(Tools/Options/Calculation).