Re: [libreoffice-users] ISNUMBER help

The "issue" is visible / replicate-able on my computer.

Your problem is your input parameter, you have:  =ISNUMBER(A1:C1)

A1:C1 references a RANGE, but the ISNUMBER function expects a VALUE, or 
a single cell reference.

If I enter =A1:C1 in any cell in columns A-C it shows TRUE, but by 
clearing the cell formatting I can see that the actual return value is 
the column index (A=1).

If I enter =A1:C1 in any cell beyond column C it returns #VALUE! 
Apparently ISNUMBER translates this to FALSE, rather then propagating 
the error value.

I don't understand why it's doing this, what this particular formula is 
actually supposed to do.

To fix you will need to reference a single cell, like this: =ISNUMBER(A1)

You can use AND to link a number of them together, I suspect this will 
get the result you want:
    =AND(ISNUMBER(A1), ISNUMBER(B1), ISNUMBER(C1))



On 6/10/25 16:29, quickinbox99-lo@yahoo.com wrote:
> I am not familiar with mailing lists, so hopefully this message associates with the correct thread. I have uploaded an 
> example document at https://filebin.net/uduv0iqejt3y94y5 which hopefully helps demonstrate the issue I am having. I 
> have included a screenshot from my machine in the event that the issue only occurs for me. All cells with 
> "TRUE" and "FALSE" have the same formula in them.
> -A

--
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