Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Improvements for text finding functions | Excel Discussion (Misc queries) |