Re: [libreoffice-users] Calc Question

I believe the expresion is a boolean expresion where you compare if the 
COUNTIF(F4;K380,F4) is equal to 1.
It means that if the count of cells in the range F4:K380 having the 
value matching the contents of F4 is 1 (only 1 such a cell) let the 
result is true.

There is a typo in the syntax; it should be =COUNTIF(F4:K380;F4)=1

Regards,
Jiri

Dne 11.4.2011 18:01, Johnny Rosenberg napsal(a):
> sön 2011-04-10 klockan 16:52 -0400 skrev Chris Gummo:
> > The formula that we use is below. We use it in the Data Vailidation section
> > and not in every cell. I have not been able to get it to work.
> >
> > =COUNTIF(F4;K380,F4)=1
> >
> > Thanks
> > Chris
>
> Sorry for being some kind of an idiot, but what does the ”=1” mean at
> the end of the formula?

--
OBUTEX spol. s r.o.
Ing. Jiří Hladůvka

Zlatovská 22
911 05 Trenčín
EU Slovakia
--

mailto:admin@obutex.com
http://www.obutex.com


--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted