Confirm True in Logical Test using Find

HI all,

I'm trying to use the following formula to verify if the "," is within a cell.
Something is not right, because even for True conditions, I'm getting a False
return.
I think my True logical test is not written right.
Can someone please verify and provide the logical test for True part of the function.

=IF(FIND(",",C808)=TRUE,LEFT(C808,FIND(",",C808)-1),C808)

Thanks,

BDB

FIND doesn'r return a logical value -- it returns either a number or a #VALUE! error. So test for ISNUMBER()

Hi,

FIND produces a number, not a boolean result. This should work for you:

=IF(ISNUMBER(FIND(",",C808)),LEFT(C808,FIND(",",C808)-1),C808)

Note also that if you have the comma selected as a thousand separator, excel may well ignore it if your data is entirely numerical.