software

I have a column of numerical values and I need to choose cells based on
whether or not the value of the ending digit in the cell is equal to 1. For
example I would want to choose a cell whose data is 12341 but not choose a
cell whose data is 1234 .

Any help is appreciated

Thank you

Something like this?

=RIGHT(A1,1)

--
Regards,
Davequot;Thruwayquot; wrote:

gt; I have a column of numerical values and I need to choose cells based on
gt; whether or not the value of the ending digit in the cell is equal to 1. For
gt; example I would want to choose a cell whose data is 12341 but not choose a
gt; cell whose data is 1234 .
gt;
gt; Any help is appreciated
gt;
gt; Thank you

If the test is for a numeric value, try this:

=--RIGHT(A1,1)=1
or
=MOD(A1,10)=1
Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Thruwayquot; wrote:

gt; I have a column of numerical values and I need to choose cells based on
gt; whether or not the value of the ending digit in the cell is equal to 1. For
gt; example I would want to choose a cell whose data is 12341 but not choose a
gt; cell whose data is 1234 .
gt;
gt; Any help is appreciated
gt;
gt; Thank you