Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 17 Jan 2013 11:43:21 +0100calc select number within a specific range formulahttps://ask.libreoffice.org/en/question/9975/calc-select-number-within-a-specific-range-formula/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.Thu, 17 Jan 2013 05:01:02 +0100https://ask.libreoffice.org/en/question/9975/calc-select-number-within-a-specific-range-formula/Answer by JohnSUN for <p>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.</p>
https://ask.libreoffice.org/en/question/9975/calc-select-number-within-a-specific-range-formula/?answer=9987#post-id-9987Just
=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 1Thu, 17 Jan 2013 11:43:21 +0100https://ask.libreoffice.org/en/question/9975/calc-select-number-within-a-specific-range-formula/?answer=9987#post-id-9987