Insert a variable dependant on content of specific cells

[Colin Hayes]

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

 

[David Biddulph]

=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.

 

[CLR]

Put this in D1 and copy down........

=IF(C1="","",IF(ISNUMBER(C1),3,4))


Vaya con Dios,
Chuck, CABGx3

 

[Colin Hayes]

Hi

OK Thanks for your help on this- it's working fine now.

^_^

 

[CLR]

You're welcome...........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3

 

[Colin Hayes]

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]

Hi

OK please ignore my last post - I managed to work out the problem.

^_^

Best Wishes