James, There are 2 basic ways to accomplish this: Round the values at calculation time, so they’ll become real 0’s
Change the formula to MINIFS(B:B;B:B;">=1”) Success, Rob > Op 29 jan. 2021, om 20:06 heeft James <[email protected]> het volgende > geschreven: > > Another problem. > > Some of the numbers display as 0 but are calculated so have fractions like > 0.0000000812344372353 > I want to find the last row that displays as non-zero. > > > On 2021-01-29 6:30 a.m., Rob Jasper wrote >> James, >> >> Since a MINIF function does not exist you can use MINIFS. >> >> Change MIN(B:B) to MINIFS(B:B;B:B;">0”) >> >> Success, >> Rob >> >> >>> Op 29 jan. 2021, om 03:59 heeft James <[email protected]> >>> <mailto:[email protected]> het volgende geschreven: >>> >>>> I want to find the row in column A that corresponds to the row of a >>>> >>>> value in column B. >>>> >>>> eg. >>>> >>>> row A B >>>> 1 10 220000 >>>> 2 20 150000 >>>> 3 30 3000 >>>> 4 40 10 >>>> >>>> =some_function('A',minimum_function(B)); >>>> >>>> where minimum_function(B) returns 4 and some_function('A',4) returns the >>>> >>>> value in column A at row 4. >>> I asked the previous and someone gave me the formula: >>> >>> =INDIRECT("$A"&MATCH(MIN(B:B);B:B;0)) >>> >>> >>> It worked fine but now I have some rows with zeros (more than one row): >>> row A B >>> 1 10 220000 >>> 2 20 150000 >>> 3 30 3000 >>> 4 40 10 >>> 5 50 0 >>> 6 60 0 >>> >>> Is there a MINBUTGREATERTHANZERO function? -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
