Re: [libreoffice-users] ISNUMBER help

=On 10 Jun 2025 at 20:29, quickinbox99-lo@yahoo.com wrote:


Date sent:60;Tue, 10 Jun 2025 20:29:25 +0000

(UTC)
From: "quickinbox99-lo@yahoo.com" 
<quickinbox99-lo@yahoo.com>
To:0;"users@global.libreoffice.org" 
<users@global.libreoffice.org>
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: users+unsubscribe@global.libreoffice.org
> 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:mikes@guam.net&#160;
mailto:msetzerii@gmail.com
mailto:msetzerii@gmx.com
Guam - Where America's Day Begins&#160;
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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