At 10:31 10/09/2007 +0800, Lawrence Low wrote:
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 Calc. 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.
You can do this using one of what Calc calls its database
functions. (These are unrelated to the database component of
OpenOffice, called Base.) Give your column of values a column label,
e.g. "Values". Then repeat that header and put the condition you
need - here "positive" - in the cell below that. So you have
something like this:
A1: Values
A2: -50
A3: -25
A4: 0
A5: 25
A6: 50
A7:
A8: Values
A9: >0
Now the formula you need is =DMIN(A1:A6;"Values";A8:A9). A1:A6 is
the database you are searching; "Values" is the column you are
selecting (redundant in this case), and A8:A9 specifies where the
condition is found, complete with its own column header. You can
leave the column headers empty, in which case the second parameter
should be just "", but you do still need the empty cell. And you may
choose to put >0 or >=0 in A8, depending on your precise
interpretation of "positive".
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
