A copy paste formula not working

[HeriKuri]

I copied a table with many formulas in it and pasted it to some other place, adjusted some variables according to new cell names, the formula is %100 same now but however, first table shows results but copy paste one doesn't. Screenshots below, I can also share the excel file if needed.

Formula for O7; =IFERROR(C7*D7/M7*F49*SQRT((3,14*N7)^2+M7^2)/1000;"")
Formula for AG7; =IFERROR(U7*V7/AE7*F53*SQRT((3,14*AF7)^2+AE7^2)/1000;"")

Capture.PNG

Capture2.PNG

Thanks in advance.

[6StringJazzer]

Please attach the file. We cannot see all the cells referenced in the formulas. Also it appears you are using merged cells, which is almost always a bad idea.

[HeriKuri]

I don't know what happened but after I messed around a bit, it started working but still, I started using Excel for the first time in my life like 4-5 days ago and this is the first thing I'm doing to help me with my work, for easy calculations, so if you can take a look at it and point me my errors, it would still be appreciated. Also when I copy paste a table, it changes the formulas accordingly but there should be a fixed cell for the entire column, like an F49 in the formula of cells AG7:AG23, so it comes out as F49 at AG7, F50 at AG8, F51 at AG9... Is there a way to change all of them to those F50 F51 F52 Fxxx to F49 in a few smart moves or should I keep typing F49 into all of them manually?

[JeteMc]

To maintain a reference to cell F49 as the formula is dragged down the rows place a $ after the F (F$49)
To maintain a reference to cell F49 when the table is copied from B3:R24 to T3:AJ24 place a $ in front of the F ($F49)
To maintain a reference to cell F49 in both instances place a $ in front of and after the F ($F$49)
Note The above are called mixed and absolute references. You may want to look up absolute reference as the concept is important when using Excel. You'll also find that the F4 key is useful in quickly applying the type of reference to a formula.
Let us know if you have any questions.

[HeriKuri]

THIS is what I needed, thank you very much..

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.