Yah, you are right. Any possibility of mentioning this in Help? > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, May 08, 2006 1:47 PM > To: [email protected] > Subject: Re: [users] Calc - Vlookup 4th parameter (Sort > order) is not accepting "True" or "false" > > Kirill S. Palagin wrote: > > When constructing formula with vlookup I need to specify 4 > parameter > > (Sort order). > > Help clearly says that it could be True or False, yet when I put > > either as 4th parameter I get "#NAME?" error. > > Enclosing True or False in either single quotes does not > chang anything. > > Using double quotes produces Err:502 as formula result. > > > > The only way to get it work is to use either 0 or 1. > > > > What is wrong? Is there a bug in function or wrong > description in Help > > or I do something in a wrong way? > > The TRUE and FALSE constants for formulas have to be entered > in the language of the configured locale setting (default is > your system locale). But they are then converted to 1 or 0 anyway. > > Niklas > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
