Microsoft KB Archive/98958

{|
 * width="100%"|

XL4: Formula with SELECT and OFFSET Is Incorrect

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
On page 245 of &quot;User's Guide 2&quot; in the first paragraph, the example for the OFFSET function reads:

  =SELECT(OFFSET(ACTIVE.CELL,B,-3))

This is a misprint. The letter B should be the number 8 (eight). The function example should read:

  =SELECT(OFFSET(ACTIVE.CELL,8,-3))