Excell formulas

[Guest]

As you know in office you can add a formula to a cell and then drag this
formula down the colum, for example when doing household credit and debit
accounts. Although the formula workls if I enter it in an individual cell,
dragging it down only repeats the number in the previous cell. This is a
recent problem if anyone can assist?

 

[Bernard Liengme]

Show us what the formula looks like? Wonder it you have absolute references.

 

[Guest]

I'm thinking maybe calculation got set to manual. Does F9 update the
formulas? Go to Tools-Options-Calculation and check Automatic.

 

[Guest]

Hi Chris,

I am now having the same problem you experienced. Have you solved that
problem? Do you mind to share the trick? Thanks,

Grace

 

[T. Valko]

Here are a couple of things to look at.

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic

Your formulas might be using absolute referencing when they should be using
relative referencing. For example:

=SUM(A$1:B$1)

When you copy that formula down a column the references don't change so all
copies will return the same result.

=SUM(A1:B1)

When you copy that formula down a column the references will change so all
copies will return the expected result.