RE: how do i average the 2 smallest number in a range of six numbe

From: tjtjjtjt (tjtjjtjt_at_discussions.microsoft.com)
Date: 11/23/04 

Date: Mon, 22 Nov 2004 18:33:04 -0800

You are missing a few parentheses, but Frank and Jerry both provided more
concise formulas anyway.

tj

"zetatstrat" wrote:

>
>
> "zetatstrat" wrote:
>
> > I tried (small(a1:a6,1)+small(a1:a6,2)/2, but got an incorrect number.
> > Is there problem with syntax, or perhaps another to accomplish what I am
> > trying to achieve.
> >
> > Zetstrat
>
> Thanks to everyone for their help

Relevant Pages

  • RE: Indexing service server 2008 iis7.0 error
    ... I do not know where I got that syntax but it does not work in Server 2008. ... "Jerry C" wrote: ... Dim daIS As New OleDbDataAdapter ...
    (microsoft.public.data.oledb)
  • RE: Join Query Expression
    ... Jerry, thanks for the response. ... I am having trouble with the syntax though. ... manually fix the problem records. ... Table 2 has employee name in this order: ...
    (microsoft.public.access.queries)
  • Re: Secure Scripts
    ... You'd think a search on encoding vbscript would have ... Jerry ... > Microsoft Script Encoder ...
    (microsoft.public.windows.server.scripting)
  • Re: array question (newbie)
    ... Hello Jerry, ... And refering to a particular element, which syntax is correct? ... Simon Taylor ...
    (comp.lang.perl.misc)
  • RE: how do i average the 2 smallest number in a range of six numbers
    ... "zetatstrat" wrote: ... > Is there problem with syntax, or perhaps another to accomplish what I am ...
    (microsoft.public.excel.misc)