COUNTING A CELL's DATA

**koa786** · 09-10-2008, 03:29 AM

Hey all,

i want to count the integers/numbers in a particular cell. For example
a1 = 123456789

now i want a formula which count these numbers for me and give me result that will be = 9. Can any one help me on it.

Please reply soooon

**SamuelT** · 09-10-2008, 04:14 AM

Hi,

Assuming you data is in A1, try:

Please Login or Register  to view this content.

HTH,

SamuelT

**sglife** · 09-10-2008, 04:24 AM

use this if you don't want to count the decimal point

Please Login or Register  to view this content.

**koa786** · 09-10-2008, 04:25 AM

Thanks buddy it worked

**koa786** · 09-10-2008, 04:32 AM

NOW ONE MORE THING.

IF I WANT TO USE AN IF STATEMENT USING THIS FORMULA WHAT WILL BE THE STATEMENT.

i mean i want some like
if LEN(A1) = 12 return me TRUE else FALSE

REPL SOON

**arthurbr** · 09-10-2008, 04:55 AM

Hi Koa,
please restrain from using upper case phrases in your thread.
As you know, on the Net, this is equivalent to shouting, which, I think, is not necessary here.
Cheers

**additude** · 09-10-2008, 06:20 AM

Please Login or Register  to view this content.

I'm really sure this conditional IF format can also be found in the Excel help section.

**koa786** · 09-10-2008, 10:32 PM

ok arthur i'll try not to write in capital letters.

thanks attitude. it worked.

i am not very much familiar with the excel help section. i try to use that but couldn't find it out.

any ways thanks for the help

**koa786** · 09-11-2008, 12:42 AM

here i am again with another problem.

the problem is this.

cell A1 has a value = 1234567.12

now i want that if the values before decimal is = 7 and after decimal is = 2 return true, else false.

reply soon

**sglife** · 09-11-2008, 02:59 AM

=and(mod(int(a1),10)=7,int(mod(a1,1)*10)=2)

**koa786** · 09-17-2008, 10:26 PM

i can't make this formula work. is there any other option.

let me repeat my question.

Cell A1 = 1234567.12

If (Len(A1)[B4 decimal]=7 and Len(A1)[After Decimal] = 2, TRUE,FALSE)

can any one please make a formula for it.

**additude** · 09-18-2008, 05:48 AM

Try this:

Please Login or Register  to view this content.

This will count out to 50 decimal places. That should be enough...but 3 would suffice for your =2 condition.

But this will give you flexibility. Being as we are just counting the LEN() of the characters before the decimal point, Number-INT(Number) or TRUNC() will work equally.