XL4: Formula with SELECT() and OFFSET() Is Incorrect

ID: Q98958


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 "User's Guide 2" 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)) 


REFERENCES

"User's Guide 2," version 4.0, page 245.

Additional query words: 4.00a XL4

Keywords :
Version : WINDOWS:4.0,4.0a; MACINTOSH:4.0
Platform : MACINTOSH WINDOWS
Issue type :


Last Reviewed: April 5, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.