when I use Ctrl+D to copy a formula, it does not compute right.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ctrl+D is copying the formula down but then it is not computing according to
the formula. It only copies the answer from the cell I am doing the Ctrl+D
from. For example, the formual in the cell is =L2-H2 (the correct answer in
this instance is 20.00). The very next cell reads =L3-H3 but it shows 20.00
rather than whatever answer it would be if it computed L3-H3.
 
You may have calculation set to manual, to fix

Tools > Options > Calculation > Automatic
 
Probably you have your 'Calculation' set to manual.

<Tools> <Options> <Calculation> tab,

And click on "Automatic".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Attempting to Copy a IF Function 3
formulas copying from sheet to sheet 6
Using CTRL to select cells for a formula 2
Formulas to Values 11
Can't get a formula to work in each row of an Excel sheet. 2
Copying formulas - problem with the sum 1
I am having some trouble with a long formula and multiple spreadsh 6
Re: Convert Array Formulas to Regular Formulas 0

Back
Top