calc select number within a specific range formula [closed]
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.