Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a variable dependant on content of specific cells
HI In column C I have a list of reference numbers. Some of these reference numbers only contain numbers and some contain numbers and letters. In column D I need to put a number 3 three for those cells in C which contain just numbers , and 4 for those cells which contain combined numbers and letters. Can some one help with some code for this , please? Any help appreciated. Best Wishes |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a variable dependant on content of specific cells
=IF(ISNUMBER(-C1),3,4)
If you are sure that the column C numbers will be real numbers, and not text that looks like numbers, then you can omit the minus sign. If you want to add an extra test for column C being blank, you can do that. -- David Biddulph "Colin Hayes" wrote in message ... HI In column C I have a list of reference numbers. Some of these reference numbers only contain numbers and some contain numbers and letters. In column D I need to put a number 3 three for those cells in C which contain just numbers , and 4 for those cells which contain combined numbers and letters. Can some one help with some code for this , please? Any help appreciated. Best Wishes |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a variable dependant on content of specific cells
Put this in D1 and copy down........
=IF(C1="","",IF(ISNUMBER(C1),3,4)) Vaya con Dios, Chuck, CABGx3 "Colin Hayes" wrote: HI In column C I have a list of reference numbers. Some of these reference numbers only contain numbers and some contain numbers and letters. In column D I need to put a number 3 three for those cells in C which contain just numbers , and 4 for those cells which contain combined numbers and letters. Can some one help with some code for this , please? Any help appreciated. Best Wishes |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a variable dependant on content of specific cells
Hi OK Thanks for your help on this- it's working fine now. ^_^ In article , CLR writes Put this in D1 and copy down........ =IF(C1="","",IF(ISNUMBER(C1),3,4)) Vaya con Dios, Chuck, CABGx3 "Colin Hayes" wrote: HI In column C I have a list of reference numbers. Some of these reference numbers only contain numbers and some contain numbers and letters. In column D I need to put a number 3 three for those cells in C which contain just numbers , and 4 for those cells which contain combined numbers and letters. Can some one help with some code for this , please? Any help appreciated. Best Wishes |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a variable dependant on content of specific cells
You're welcome...........thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "Colin Hayes" wrote: Hi OK Thanks for your help on this- it's working fine now. ^_^ In article , CLR writes Put this in D1 and copy down........ =IF(C1="","",IF(ISNUMBER(C1),3,4)) Vaya con Dios, Chuck, CABGx3 "Colin Hayes" wrote: HI In column C I have a list of reference numbers. Some of these reference numbers only contain numbers and some contain numbers and letters. In column D I need to put a number 3 three for those cells in C which contain just numbers , and 4 for those cells which contain combined numbers and letters. Can some one help with some code for this , please? Any help appreciated. Best Wishes |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a variable dependant on content of specific cells
In article , CLR
writes Put this in D1 and copy down........ =IF(C1="","",IF(ISNUMBER(C1),3,4)) Vaya con Dios, Chuck, CABGx3 Hi Me again Suddenly , I find this doesn't work. I did test it out before , and it seemed to work fine. Now , I'm trying it again in my workbook. It should return 3 for cells with all numbers , and 4 for cells with numbers and letters combined. However , it just returns 4 for everything. This is what I'm using : =IF(H2="","",IF(ISNUMBER(H2),3,4)) Curiously , if I do a simple test in a blank wb with just a few cells containing numbers and letters , it works. When I run it in my larger wb , it doesn't! Can you advise? Thanks. "Colin Hayes" wrote: HI In column C I have a list of reference numbers. Some of these reference numbers only contain numbers and some contain numbers and letters. In column D I need to put a number 3 three for those cells in C which contain just numbers , and 4 for those cells which contain combined numbers and letters. Can some one help with some code for this , please? Any help appreciated. Best Wishes |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a variable dependant on content of specific cells
Hi OK please ignore my last post - I managed to work out the problem. ^_^ Best Wishes In article , Colin Hayes writes In article , CLR writes Put this in D1 and copy down........ =IF(C1="","",IF(ISNUMBER(C1),3,4)) Vaya con Dios, Chuck, CABGx3 Hi Me again Suddenly , I find this doesn't work. I did test it out before , and it seemed to work fine. Now , I'm trying it again in my workbook. It should return 3 for cells with all numbers , and 4 for cells with numbers and letters combined. However , it just returns 4 for everything. This is what I'm using : =IF(H2="","",IF(ISNUMBER(H2),3,4)) Curiously , if I do a simple test in a blank wb with just a few cells containing numbers and letters , it works. When I run it in my larger wb , it doesn't! Can you advise? Thanks. "Colin Hayes" wrote: HI In column C I have a list of reference numbers. Some of these reference numbers only contain numbers and some contain numbers and letters. In column D I need to put a number 3 three for those cells in C which contain just numbers , and 4 for those cells which contain combined numbers and letters. Can some one help with some code for this , please? Any help appreciated. Best Wishes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert cell content and shift cells down | Excel Worksheet Functions | |||
Sum of Cells if Row Contains a Specific Variable | Excel Worksheet Functions | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) |