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.