Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

On 1-12-2014 20:14, Luuk wrote:
> On 1-12-2014 14:58, Brian Barker wrote:
> > At 14:04 01/12/2014 +0100, Carlo Strata wrote:
> > > I suppose (!) there is an addition to the two behaviors ("Err:511" and
> > > "#N/A", respectively from LO and Excel) described by Luuk: Excel
> > > evaluate only the part it calculate and not the entire formula or lose
> > > the internal "#N/A" in calculations. I cannot check this because I
> > > have not Excel anymore on my notebook...
> > >
> > > In other words, if you use a formula like this:
> > > =IF(1=1;3;LOOKUP(;"peace"))
> > >
> > > LO check the entire formula and answer "Err:511" and Excel? Someone
> > > may check for this?
> >
> > Excel needs comma separators instead of semi-colons, of course - but the
> > equivalent formula yields 3 in Excel 2010. If you change the test to
> > 1<>1 to force it to evaluate the LOOKUP(), it gives a #VALUE! error
> > because "peace" is a text value, not an array. If you substitute an
> > array here, it gives #N/A. In either of these latter cases, if you ask
> > it to show calculation steps, it has evaluated the inequality to FALSE,
> > identified the LOOKUP as the next thing to evaluate, and says "The next
> > evaluation will result in an error."
> >
> > Brian Barker
>
> Excel does not need comma separators, this is only true for the English
> version?
>
> If you have an Italian or Dutch, than a ';' is used as separator.
>
> In fact, the 'List separator' that is defined in the regional setting of
> Windows is used as separator.

I should read the complete thread before posting a reaction... ;-)

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted