software

When I copy my fx down, the answers I get are the same as the cell where I
initially wrote the formula (the formula changes to match the correct cells,
but the result stays the same). If I re-type the formula, I get the correct
answer, but it does not work when I copy the formula down.

For example:

A B C
1 2 2 =A1*B1 (result of fx is 4)
2 2 3 =A2*B2 (result of fx is 4) - formula is copied down
3 2 4 =A3*B3 (result of fx is 4) - formula is copied down
4 2 5 =A4*B4 (result of fx is 4) - formula is copied down

If I was to re-type the formula in C2, I get quot;6,quot; which is the correct
answer. Any clue on what's going on?
Ensure that calculation is set to automatic. Go to the Tools
menu, choose Options, then the Calculation tab. Select Automatic.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;ziakquot; gt; wrote in message
news
gt; When I copy my fx down, the answers I get are the same as the
gt; cell where I
gt; initially wrote the formula (the formula changes to match the
gt; correct cells,
gt; but the result stays the same). If I re-type the formula, I
gt; get the correct
gt; answer, but it does not work when I copy the formula down.
gt;
gt; For example:
gt;
gt; A B C
gt; 1 2 2 =A1*B1 (result of fx is 4)
gt; 2 2 3 =A2*B2 (result of fx is 4) - formula is copied
gt; down
gt; 3 2 4 =A3*B3 (result of fx is 4) - formula is copied
gt; down
gt; 4 2 5 =A4*B4 (result of fx is 4) - formula is copied
gt; down
gt;
gt; If I was to re-type the formula in C2, I get quot;6,quot; which is the
gt; correct
gt; answer. Any clue on what's going on?
gt;
gt;
It sounds like you used Dollar Signs in the top formula....remove them and
then copy down again..........

Vaya con Dios,
Chuck, CABGx3
quot;ziakquot; wrote:

gt; When I copy my fx down, the answers I get are the same as the cell where I
gt; initially wrote the formula (the formula changes to match the correct cells,
gt; but the result stays the same). If I re-type the formula, I get the correct
gt; answer, but it does not work when I copy the formula down.
gt;
gt; For example:
gt;
gt; A B C
gt; 1 2 2 =A1*B1 (result of fx is 4)
gt; 2 2 3 =A2*B2 (result of fx is 4) - formula is copied down
gt; 3 2 4 =A3*B3 (result of fx is 4) - formula is copied down
gt; 4 2 5 =A4*B4 (result of fx is 4) - formula is copied down
gt;
gt; If I was to re-type the formula in C2, I get quot;6,quot; which is the correct
gt; answer. Any clue on what's going on?
gt;
gt;

Sounds like Automatic Calculations have been turned off.

Tools --gt; Options --gt; Calculation Tab --gt; Check box quot;Automaticquot;

HTH,
Elkarquot;ziakquot; wrote:

gt; When I copy my fx down, the answers I get are the same as the cell where I
gt; initially wrote the formula (the formula changes to match the correct cells,
gt; but the result stays the same). If I re-type the formula, I get the correct
gt; answer, but it does not work when I copy the formula down.
gt;
gt; For example:
gt;
gt; A B C
gt; 1 2 2 =A1*B1 (result of fx is 4)
gt; 2 2 3 =A2*B2 (result of fx is 4) - formula is copied down
gt; 3 2 4 =A3*B3 (result of fx is 4) - formula is copied down
gt; 4 2 5 =A4*B4 (result of fx is 4) - formula is copied down
gt;
gt; If I was to re-type the formula in C2, I get quot;6,quot; which is the correct
gt; answer. Any clue on what's going on?
gt;
gt;