Formula Problem

[Tracey BVS]

When I drag and drop a formula it is copying the cells only and not the
result, however when I go into the cell and press enter the result is
correct.

 

[Jerry W. Lewis]

Tools|Options|Calculate
If Manual is checked, change it to Automatic.

Jerry

 

[Frank Kabel]

Hi
goto 'Tools - Options - Calculate' and enable 'Automatic calculation'