Excel formula...

[CM]

I am entering dates into column A and in Column B i would like to add 80 days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply to
entire column of B for each date that is entered in Col A.

 

[Jacob Skaria]

Enter the below formula in cell B2
=A2+80

and select the cell B2. Double click the fill handle (bottom right) of the
selection rectangle.

 

[CM]

Thanks for the help and quick reply.

Enter the below formula in cell B2
=A2+80

and select the cell B2. Double click the fill handle (bottom right) of the
selection rectangle.

 

[Lewis]

I entered a formula in C1 that is =A1*B1. I want to fill down 20 rows so
that the formula becomes =a2*b2, =a3*b3 and so on. The fill down comand and
also the copy paste comand copies the formula but the result stays the same
as C1 for all rows. Then when I click in the formula bar and hit enter the
correct result appears.
How can I get the fill down or copy paste to work properly?

 

[Dave Peterson]

Make sure you have excel's calculation mode set to automatic.

In xl2003 menus:
tools|options|calculation tab

It's hidden under the Office button|excel options in xl2007.

 

[David Biddulph]

Tools/ Options/ Calculation
Set to Automatic, not Manual.

 

[Gord Dibben]

Button>Excel Options>Formulas will unhide the calculation options.


Gord Dibben MS Excel MVP