On Jul 26, 11:01 am, via135 wrote:

i'm having values in multiples of 100 in COL A.
i want the quotients in COL B [divisor 500] & COL C
[divisor 100] explained as under:


There may be many solutions. I don't know if this is what your
teacher had in mind, but this is what I came up:

B1: =INT( (A1-1) / 500 )

C1: =INT( ( MOD(A1-1, 500) + 1 ) / 100 )

I suspect the latter can be simplified. I didn't give it more than a
moment's thought.

Let me know what grade I get ;-).


On Jul 26, 11:01*am, via135 wrote:

hi

i'm having values in multiples of 100 in COL A.
i want the quotients in COL B [divisor 500] * & COL C [divisor 100]
explained as under:

COL "A" * * * * * *- * * * * *COL "B" * *- * COL "C"

100 * * * * * * * * * - * * * * * 0 * * * * * * * * * * *1
200 * * * * * * * * * - * * * * * 0 * * * * * * * * * * *2
500 * * * * * * * * * - * * * * * 0 * * * * * * * * * * *5
600 * * * * * * * * *- * * * * * 1 * * * * * * * * * * * 1
700 * * * * * * * * *- * * * * * 1 * * * * * * * * * * * 2
1000 * * * * * * * *- * * * * * *1 * * * * * * * * * * *5
1200 * * * * * * * *- * * * * * 2 * * * * * * * * * * * 2
1500 * * * * * * * *- * * * * * *2 * * * * * * * * * * *5
1600 * * * * * * * *- * * * * * 3 * * * * * * * * * * * 1
1900 * * * * * * * - * * * * * *3 * * * * * * * * * * * 4
2000 * * * * * * * *- * * * * * *3 * * * * * * * * * * *5
2100 * * * * * * * *- * * * * * * 4 * * * * * * * * * * 1
2500 * * * * * * * - * * * * * * 4 * * * * * * * * * * * 5
50000 * * * * * *- * * * * * *99 * * * * * * * * * * * 5
*.
.
.
so on

any hlp pl..?

-via135