Fixed Excel on cell dragging not taking formula or correct result

Two option need to verify on Excel

Make workbook calculation on automatic

1. Go to Right side and click File > Options.
2. Click on the Formulas.
3. Check the Workbook Calculation, choose the option to Automatic.

Enable fill handle and cell drag-and-drop option

1. Go to Right side and click File > Options.
2. Click on the Formulas button.
3. Check the Editing Options, check the Enable fill handle and cell drag-and-drop box.