Absolute column and absolute row vs. relative column and absolute row
Using formulas in Microsoft Excel
As you know, the formula in Microsoft Excel becomes an extremely powerful when we make a calculation in a cell. Microsoft Excel’s primary math operators are +, -, /,* and ^ for exponentiation.
When we try to make a formula in Microsoft Excel always starts with an equal sign (=).
Point to remember, an absolute address uses specific address/cell and does not change when we copy the formula. However, if we use a relative address that based on the current cell’s location the result depends on the contain cell addresses.
On this picture below, I made an experiment between absolute column and absolute row versus relative column and absolute row. Finally, I find the same result.
