•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Difference between ADDRESS(1,1,1) and ADDRESS(1,1,4)?
Our take
The ADDRESS function in spreadsheet applications serves to generate cell references based on specified row and column numbers, but it offers flexibility in reference styles. Specifically, ADDRESS(1,1,1) yields an absolute reference, returning the text "$A$1," while ADDRESS(1,1,4) produces a relative reference, giving "A1." This distinction affects how formulas behave when copied across different cells. Choosing between them depends on whether you need a fixed reference that remains constant or a relative one that adjusts based on its new position, thereby enhancing your spreadsheet's functionality.
ADDRESS(1,1,1) returns the text $A$1, and ADDRESS(1,1,4) returns the text A1. Other than the difference of the text strings, what other practical difference is there? In what situation would you need to use one over the other?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience