Duplicate a formula in the bottom cell but changing the other cells references with the new row's ones?

[Fra92]

If I have column A and B and I have an IF formula with 64 nested conditions on A2, referring to the exact value (alphanumeric) of A1, how can I have this formula on B2 referring to B1 without changing every reference manually? I can just do find and replace on any text editor, but I need this to be in almost 300 rows, not worth to do manually :D

 

[Fra92]

Re: How can I duplicate a formula in the bottom cell but changing the other cells references with the new row's ones?

Okay I just realize I have just to copy the actual cell and it will change automatically when pasted, I was copying the formula from the formula textbox so it was the same as the original, sorry for the dumb question, I just started some days ago, you can close the topic