=On 10 Jun 2025 at 20:29, [email protected] wrote:
Date sent:60;Tue, 10 Jun 2025 20:29:25 +0000 (UTC) From: "[email protected]" <[email protected]> To:0;"[email protected]" <[email protected]> Subject:;Re: [libreoffice-users] ISNUMBER help > I am not familiar with mailing lists, so hopefully this message > associates</span> > with the correct thread. I have uploaded an example document</div>> > athttps://filebin.net/uduv0iqejt3y94y5 which hopefully helps demonstrate > the issue I am having. I have included a screenshot from my machine in > the</span> > event that the issue only occurs for me. All cells with "TRUE" and "FALSE" > have the same formula in them. -A Looked at spreadsheet, and saw same results of same formula give TRUE and FALSE values? No clue why that is? Even tried changing references to absolute values and got same different results with $A$1:$C$1? First Issue. From what I found, ISNUMBER is suppose to check a cell not a range? So, why it sometime works, and other times doesn't? Tried this formula, and get a consistant result =MIN(ISNUMBER(a1),ISNUMBER(b1),ISNUMBER(c1)) worked. Since it checks each cell individually as being a number, and if any are not it returns a 0, which will be the min value. Did find this option that might work. =IF(COUNT(A1:C1) = COUNTA(A1:C1), 1, 0) Can use True and False instead of 1 and 0, and format at Bolean. If all values are number COUNT and COUNTA match so True, but is anything isn't they differ. Did notice that neither count or counta count empty cells? Perhaps someone can figure why formula for same cells with ISNUMBER gives different results? Interesting. > -- > 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 +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired)60; mailto:[email protected]  mailto:[email protected] mailto:[email protected] Guam - Where America's Day Begins  G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- 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
