[libreoffice-users] Re: Calc Formula Help

Hi,


macroC wrote:
> So I have two columns of data, column A which has a single character (A,
> G, or T) and column B which has a number. I am trying to determine the
> minimum value in B that corresponds to an "A" in column A.
>
> This is the forumla I came up with after looking at tutorials and reading
> the documentation:
>
> =MIN(IF(A1:A7="A",B1:B7))
>
> But this simple gives a #VALUE error. Can anyone help me figure out what
> is wrong with the formula?
>
> Thanks.

Your formula is correct, but it is an array formula.
An array formula must be validate with key combinaison Ctrl+Shift+Enter, not
simply Enter.

Gérard

--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Formula-Help-tp3303917p3303997.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@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