Reference Named Cells and Ranges
A simple way to ensure that you’re referencing the specific data you want to reference is by assigning a name to the cell, or more typically to a range of cells, that you want to reference. For example, the WORKDAY function allows an argument providing specific non-work days, such as holidays. This is very convenient because not everyone celebrates the same holidays.
To simplify the process of creating formulas that refer to a specific range of data, and to make your formulas easier to read and create, you can refer to a cell or range of cells by a name that you define. For example, you might use the name Interest for a cell containing an interest rate, or you might use the name Holidays for a range of cells containing ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access