Counting
 

I really need help here.

I need to count how many times a number or portion of that number is in a
specific cell. IE: A1 is 101 I need to know how many times 10 or a portion
of 10 is in that number. The answer in this case would be 11. If the
value of A1 is 90 the answer would be 9.

Can anyone help??

--
John Chaput

Counting
 

Try this formula to see if you get what you need.

=ROUNDDOWN(A1/10,0)
Value Result
901 90
101 10
10 1
999 99




On Aug 15, 1:04 pm, John wrote:
I really need help here.

I need to count how many times a number or portion of that number is in a
specific cell. IE: A1 is 101 I need to know how many times 10 or a portion
of 10 is in that number. The answer in this case would be 11. If the
value of A1 is 90 the answer would be 9.

Can anyone help??

--
John Chaput

Counting
 

One way:

=CEILING(A1/10,1)

In article ,
John wrote:

I really need help here.

I need to count how many times a number or portion of that number is in a
specific cell. IE: A1 is 101 I need to know how many times 10 or a portion
of 10 is in that number. The answer in this case would be 11. If the
value of A1 is 90 the answer would be 9.

Can anyone help??

Counting
 

=ROUNDUP(A1/10,0)

Tim made a mistake

"Tim879" wrote:

Try this formula to see if you get what you need.

=ROUNDDOWN(A1/10,0)
Value Result
901 90
101 10
10 1
999 99




On Aug 15, 1:04 pm, John wrote:
I really need help here.

I need to count how many times a number or portion of that number is in a
specific cell. IE: A1 is 101 I need to know how many times 10 or a portion
of 10 is in that number. The answer in this case would be 11. If the
value of A1 is 90 the answer would be 9.

Can anyone help??

--
John Chaput