Microsoft Office Tutorials and References
In Depth Information
OFFSET
As you can see in Figure 9.13, you can use the OFFSET function in conjunction with other
functions. In this particular example, the OFFSET function is used with the IF function to trigger a
response based on a cell reference. The cell reference in C13 results in an offset of Year 2, and
if the logical value of the cell reference of Year 2 is not Year 2 it defaults to the Year 1 cell of C5
as shown in Figure 9.14. See also, Chapter 2, “Managing Your Business with Functions.”
A
Cell references
C
Row
E
Text box = C14
D
Columns
Figure 9.13
The OFFSET function in
conjunction with the IF
function can be used
to create a table that
corresponds with the
logical result in cell
C14. The chart is based
on the offset table.
B
Logical result
G
The table the charts are based on
F
Year 2
A
Year 1 result
Figure 9.14
With the OFFSET
function, if the logical
result is not met,
the result defaults
to Year 1.
Search JabSto ::




Custom Search