0-9 and a-z in functions
 

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

0-9 and a-z in functions
 

=IF(AND(Sheet1!A10,Sheet1!A1<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

"Bob" wrote in message
...
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

0-9 and a-z in functions
 

Put this in A1 of Sheet2

=IF(AND(Sheet1!A1=0,Sheet1!A1<=9),Sheet1!A1,"")

and copy down

Vaya con Dios,
Chuck, CABGx3



"Bob" wrote:

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