Excel formula...

  • Thread starter Thread starter CM
  • Start date Start date
C

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.
 
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.
 
Thanks for the help and quick reply.

Jacob Skaria said:
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.
Click to expand...
 
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?
 
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.
 
Button>Excel Options>Formulas will unhide the calculation options.


Gord Dibben MS Excel MVP
 
Back
Top