software

Hi
I am working with a spreadsheet and would like to know if there is a
function to pick values from a spreadsheet into another spreadsheet when the
values are only 0-9 and make everything else to a blank or 0.Thanks
=IF(AND(Sheet1!A1gt;0,Sheet1!A1lt;10),Sheet1!A1,0)
if you want a-z also, does case (Uppercase/lowercase) matter?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Bobquot; gt; wrote in message
...
gt; Hi
gt; I am working with a spreadsheet and would like to know if there is a
gt; function to pick values from a spreadsheet into another spreadsheet when
gt; the
gt; values are only 0-9 and make everything else to a blank or 0.
gt;
gt;
gt; Thanks
gt;
gt;
Put this in A1 of Sheet2

=IF(AND(Sheet1!A1gt;=0,Sheet1!A1lt;=9),Sheet1!A1,quot;quot;)

and copy down

Vaya con Dios,
Chuck, CABGx3
quot;Bobquot; wrote:

gt; Hi
gt; I am working with a spreadsheet and would like to know if there is a
gt; function to pick values from a spreadsheet into another spreadsheet when the
gt; values are only 0-9 and make everything else to a blank or 0.
gt;
gt;
gt; Thanks
gt;
gt;