hi,
i wanted to know if i can extract numbers by 10, then sum up how many times by 10 into a whole number. The table illustrates below.
<tbody>
</tbody>
I would like to know in column B, i want to extract numbers by 10, so in A1, 10 can go into 12 once, so in column B1 it should show 10, column B2 would show nothing because 10 does not go into 9, column B3 would show 40 because 10 goes into 43 four times, column B4 would show 130 because 10 goes into 134 thirteen times, and column B5 would show nothing because 10 cannot go into 8.
Is there a formula i can use in column B that could calculate how many times 10 goes into that number then sum it up into a whole number as shown in column B??
thank you for taking the time to read this, much appreciated, look forward to hearing from you.
regards,
vlad
i wanted to know if i can extract numbers by 10, then sum up how many times by 10 into a whole number. The table illustrates below.
A | B | |
1 | 12 | 10 |
2 | 9 | |
3 | 43 | 40 |
4 | 134 | 130 |
5 | 8 |
<tbody>
</tbody>
I would like to know in column B, i want to extract numbers by 10, so in A1, 10 can go into 12 once, so in column B1 it should show 10, column B2 would show nothing because 10 does not go into 9, column B3 would show 40 because 10 goes into 43 four times, column B4 would show 130 because 10 goes into 134 thirteen times, and column B5 would show nothing because 10 cannot go into 8.
Is there a formula i can use in column B that could calculate how many times 10 goes into that number then sum it up into a whole number as shown in column B??
thank you for taking the time to read this, much appreciated, look forward to hearing from you.
regards,
vlad