excel formulas

  • Thread starter Thread starter John Nardini
  • Start date Start date
J

John Nardini

In excel, I create a formula for one cell, and it works.
After copying the formula to other cells, all cell
references have changed correctly, but the result either
shows the original cell's, or zero. I have checked the
manual formula calculation and automatic calculation, but
it doesn't work. I have even tried typing the formula in
manually, but to no avail. Any ideas?
 
Sounds like your difficulty may be about Cell References, and whether they
are Absolute (with $) or Relative (without $).......if Absolute, $A$1 stays
$A$1 wherever you move the formula, if Relative, the cell reference (A1
here), will change "relative" to where you move the cell with the formula
in it..........

hth
Vaya con Dios,
Chuck, CABGx3
 
Just to expand on CROBERTS' post. If you want to copy a
cell reference (e.g. A1) and maintain the row section of
the reference (i.e. the '1') then change A1 to A$1
(relative column, absolute row). This can be toggled by F4.

Practical example I meet regularly:
Take a number table with;
A row of numbers (1,2,3,4,5) at the top (Located in
B1,C1,D1,E1, F1). Call them column headers.

A column of numbers (1,2,3,4,5) at the left (Located in
A2, A3, A4, A5, A6. Call them row headers.

I'm building a formula in the top left cell (B2) that
refers to its row and column headers (e.g. multiplies them
together).

The formula in cell B2 would be =A2 * B1 ideally.
If I want to copy that formula to every other cell in the
grid then it needs to maintain absolute column for the
first part (A2) and absolute row for the second (B1)

The formula needs to be changed to =$A2 * B$1
YOU CAN NOW COPY THE FORMULA TO THE ENTIRE GRID!!

Regards,
John
 
Back
Top