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

Thank you very much Brian.

Have a nice evening,

Carlo

ing. Carlo Strata
-
via Botticelli 1/4
30031 Dolo - VE
Italia - Italy
-
tel. +39.041.822.0665
cell. +39.347.85.69.824
Skype carlo.strata
Google carlo.strata.69
-
carlo.strata@tiscali.it
PEC: carlo.strata@ingpec.eu


Il 01/12/2014 14:58, Brian Barker ha scritto:
> 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


--
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