Whats wrong with this?

[**{Steven}**]

I clicked on z13 and hit = and then clicked on e52 then enter. The formula
is =e52. So why is e52 showing 0.0318 and z13 is showing 0.0225? z13 should
show the exact same thing that e52 shows, right?

TIA

Steven Connor

 

[Andy B]

Hi

Check that calculation is set to Automatic: Tools / Options / Calculation
tab

Andy.

 

[wmjenner]

Right - if e52 contains a value and not a formula. If it contains
formula, then you actually copied the formula to z12 which, dependin
on the formula, may or may not give the same answer. For example, i
something being subtracted in e52's formula that doesn't get subtracte
in z12 because of the new, relative position. If the source of th
data will not change, put $ signs in front of the column and/or row t
make them absolute

 

[**{Steven}**]

e52 contains a formula, adding the values of three cells in various parts of
the sheet and then dividing it by the value in another cell on the sheet.
Would it just be safer to put the same formula in z13 that is in e52 or is
there a better way to duplicate the result of e52 in z13?

Steven