please help me

[Jagat Pavasia]

A	B	C	D	E	F
25	10			0	250
60	125			7	500
100	336			33	600
369.25	1425			526	181

<tbody>
</tbody>

I want A x B = answer in two raw ( last 3 digit n "F" and first any amount digit in "E")

what can i do ?

pls help me

 

[shg]

	a​	b​	c​	d​	e​	f​	g​	h​
1​	​	​	​	​	​	​	​	​
2​	25​	10​			0​	250​		e2: =int(a2*b2/1000)
3​	60​	125​			7​	500​		f2: =mod(a2*b2, 1000)
4​	100​	336​			33​	600​
5​	369.25​	1425​			526​	181.25​

 

[Jagat Pavasia]

	a​	b​	c​	d​	e​	f​	g​	h​
1​
2​	25​	10​			0​	250​		e2: =int(a2*b2/1000)
3​	60​	125​			7​	500​		f2: =mod(a2*b2, 1000)
4​	100​	336​			33​	600​
5​	369.25​	1425​			526​	181.25​

<tbody>
</tbody>

thank you for nice response..


but when i multiply 25 x 1000 then answer is on E2 is "25" and F2 have only "0", ( I want "000" in F2)

and if i multiply 25 x 10000 , then E2 = "250" and F2 = "000"


please update it and give me new formula

 

[AlanY]

try, format cells in column F as Custom > type > 000

Book1
	A	B	C	D	E	F
1	25	10			0	250
2	60	125			7	500
3	100	336			33	600
4	369.25	1425			526	181
5	25	1000			25	000
Sheet2

Cell Formulas
Range	Formula
E1	=INT(A1*B1/1000)
F1	=ROUND(MOD(A1*B1, 1000),0)

 

[Excel777]

try, format cells in column F as Custom > type > 000

	A	B	C	D	E	F
1	25	10			0	250
2	60	125			7	500
3	100	336			33	600
4	369.25	1425			526	181
5	25	1000			25	000

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula E1 =INT(A1*B1/1000) F1 =ROUND(MOD(A1*B1, 1000),0) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thanks for INT formula new for me