If you use relative address, the formula would be =D1+D3. If you used absolute references, the formula would be =$B$1+$B$3.
=F42 The row will have changed by one, as has the location of the formula, but the column will not have changed.
First of all, SB38 is not a formula, and neither is $B38 if that is what you mean. It needs to have an equals sign before it. If it does, then it depends on where it is copied as to what the new formula will be. If it is =SB38 then there are lots of ways it will change. If it is $B38, then the B will not change wherever it is copied, but the 38 will.
That is not a formula, it is the transitive property of equality.
The equals sign goes at the beginning of a formula, as all formulas must begin with one. It is also possible to have the equals sign at other parts of a formula too.
The formula for the area rectangle
To get the equals sign to show in a cell you put the apostrophe before it. Anything after the apostrophe is taken literally and put into a cell. So to get the equals sign to show you put: '= The equals sign will then be displayed in the cell, without the apostrophe showing. You can use it to put in a full formula without the formula actually calculating. This is good if you want to see the formula and the result beside each other in two cells. Into one you put your formula starting with the equals and in the other the same formula with an apostrophe before it. In one it will do the calculation and in the other it will show the formula including the equals sign.
P= M/No
The Transitive Property of Equality.
no it equals dont ask me no more questions
m = k/ln
The formula is E=mc2.
The correct formula is E = mc2 (E equals m c squared) and it was coined by Albert Einstein.