If Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carl - 07 May 2008 18:36 GMT

I am looking for a formula in ColC that will return TRUE is the right
character in COLA is 0 (zero).

ColA    ColC
123    FALSE
120    TRUE

Thank You in Advance.

Reply to this Message

Gary''s Student - 07 May 2008 18:40 GMT

=RIGHT(A1,1)="0"

Signature

Gary''s Student - gsnu200784

Reply to this Message

David Biddulph - 07 May 2008 19:04 GMT

Yes, but the OP should be warned that it wouldn't give TRUE if A1 contained
the number 123 *formatted* to look like 123.00; in that case the right-hand
character of the number in A1 is not zero.
--
David Biddulph

> =RIGHT(A1,1)="0"

Reply to this Message

Gary''s Student - 07 May 2008 19:24 GMT

Yes David, that is exactly the point of my formula:

if A1 is 123 then
=RIGHT(A1,1)="0"
will return FALSE,even if A1 has been formatted to display 123.000

Signature

Gary''s Student - gsnu200784

> Yes, but the OP should be warned that it wouldn't give TRUE if A1 contained
> the number 123 *formatted* to look like 123.00; in that case the right-hand
[quoted text clipped - 3 lines]
>
> > =RIGHT(A1,1)="0"

Reply to this Message