Problem copying and pasting formula

  • Thread starter Thread starter Arsenalguy
  • Start date Start date
A

Arsenalguy

Trying to copy and paste a simple formula:

H2+(H2*4.1%)

from original cell into the rest of the cells below it in the column.
When I do this, the formula references change as they should, but the
value returned is identical to the value returned in the original cell
(H2), instead of returning the appropriate calculated values for the
rest of the cells in the column. What am I doing wrong? I've done
this a million times and this is the first time this has happened!
 
sorry, I meant that the formula returns identical values to the value
calculated in the first cell in which I entered the formula in all the
cells of the column below the first cell.

I didn't mean that it returns the value of H2...it returns the value of
the calculation it performs on the value in H2, which is H2 plus 4.1% of
H2.
 
Try Tools / Options / Calculation / Change manual to Automatic :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top