Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Addressing Modes


Excel has three addressing modes: relative, absolute and mixed. Absolute addresses will reference the same cell no matter where the reference is moved or copied in a worksheet. For example, when you copy the formula =$A$3 from B3 to C5, it will still read =$A$3. A relative address will reference the same cell in relation to any cell where it is copied. For example cell B3 is one cell to the right of A3, so when you copy the formula =A3 from B3 to C5, it will now read =B5. Mixed mode addressing contains one relative coordinate and one absolute coordinate, for example $A3 or A$3. Mixed mode addressing is extremely useful for quickly generating reports using NL and NF functions. There are several examples of the use of mixed mode addressing in the Spread Company Income Statement example report that comes with Jet Reports.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments