ExcelBanter - Excel formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel formulas (https://www.excelbanter.com/excel-worksheet-functions/37594-excel-formulas.html)

When a formula is copied using the drag feature, the result in the new cells
remian the same as it is for the original cell. For example if the formula in
cell G34 is =f34*3 and the result of the formula is 120 and then that formula
is dragged to G35, the result is still 120, even though the result should be
something other than 120. This is happening on any worksheet, even after a
repair has benn done. The version of Excel is Office 2K3, Windows XP Pro is
the OS.

Maybe Calculation is set to Manual?
ToolsOptionsCalculation and select Automatic

--
Regards
Roger Govier
"Rolaxis" wrote in message
...
When a formula is copied using the drag feature, the result in the new
cells
remian the same as it is for the original cell. For example if the formula
in
cell G34 is =f34*3 and the result of the formula is 120 and then that
formula
is dragged to G35, the result is still 120, even though the result should
be
something other than 120. This is happening on any worksheet, even after a
repair has benn done. The version of Excel is Office 2K3, Windows XP Pro
is
the OS.