On 9/13/07, James <[EMAIL PROTECTED]> wrote:
>
> Paul if you try that you will find a negative number will become the
> lowest indicated. He wants the smalled positive number while ignoring
> any negative numbers. That was my first try also but testing it showed
> it was not the answer desired by his post.
>
> James
>
> Paul wrote:
> >> Hello,
> >>
> >> I would like to find the lowest positive value from a range of
> values. I
> >> could do it in Microsoft Excel but not able to do so in OpenOffice Cal.
> >> Could you please advise the syntax for inserting the formula for this
> >> purpose?
> >>
> >> I found the solution for Excel in this website -
> >>
> >>
> http://www.exceltip.com/st/Find_the_minimum_positive_value_in_Microsoft_Excel/383.html
> >> .
> >>
> >> I am currently using OpenOffice version 2.1. Appreciate your kind
> >> attention.
> >>
> >>
> > Try min() ... The arguments passed in the brackets is the range of cell
> > from which you need the lowest value.
> >
> > /paul
> >
> >
>
>
> Ok, fair call - devils in the details... However in playing around with
various options (including the link the OP had), the original formula
supplied in that link does actually work - just a minor modification.
The formula on the link was : {=MIN(IF((A1:A5>0)*(A1:A5),(A1:A5)))} (array
formular). However since calc uses ";" to separate arguments if you change
the formula to {=MIN(IF((A1:A5>0)*(A1:A5);(A1:A5)))} it works just fine.
Note, than when entering the formula you do so without the "{" or "}". When
you have finished typing the formula you must 'enter' it using
ctrl+shift+enter (have a look at the built in calc help on array formulas
for more information). The resulting formula will look as the above examples
(calc automatically puts in the 'face' brackets).
/paul
--
Processing Key for cracking HD DVD's:
09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
-----
Try Torpark; a small portable, open-source, built on Firefox browser that
enables anonymous browsing. Requires no installation :
http://www.torrify.com/
