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

ID: Q98958

The information in this article applies to:

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