Try this, and tell us what you see...
Click on a cell where the formula has been pasted (e.g. A4), then go to the formula bar and click on the formula. Which cell is highlighted (by a colored box) down in the spreadsheet? It should be A3.