No it will adapt as A1 is a relative reference
Enter the formula as suggested in B1, put your cursor on the lower right angle selecting B1, it changes to a cross then double-click, it will extend automatically

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post