calc select number within a specific range formula [closed]

asked 2013-01-17 05:01:02 +0100

vullnetyy
21 ●1 ●2 ●3

updated 2013-10-11 21:07:53 +0100

manj_k
11020 ●15 ●68 ●104

I have a row with many numbers in LibreOffice Calc. I am trying to make a formula with which I select the highest number between 0 and 1 on this row. To clarify, I want the MAX(values_between(0,1,A1:J1)) where values_between is supposed to be this function that returns an array of values that are between 0 and 1.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 01:10:45.338251

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2013-01-17 11:43:21 +0100

JohnSUN

12092 ●10 ●54 ●129

Just

=MAX((A1:J1)*(A1:J1>0)*(A1:J1<1)) press Ctrl+Shift+Enter to ARRAY formula

It returns 0 if the range does not contain a numbers between 0 and 1

edit flag offensive delete link

add a comment

Question Tools

Stats

Asked: 2013-01-17 05:01:02 +0100

Seen: 558 times

Last updated: Jan 17 '13

calc select number within a specific range formula [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-20 01:10:45.338251

1 Answer

Question Tools

Stats

Related questions

calc select number within a specific range formula [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 01:10:45.338251