Error in formula

[negi]

Hi,

I have quantity and i want convert as per SKU size.i m using below formula but not getting proper result.
Please help on this.

Qnty	SKU	Formula	Reqd Value
100	120	=INT(A2/B2)&"."&A2-B2*INT(A2/B2)	0.100
245	120	=INT(A3/B3)&"."&A3-B3*INT(A3/B3)	2.005
356	120	=INT(A4/B4)&"."&A4-B4*INT(A4/B4)	2.116
450	120	=INT(A5/B5)&"."&A5-B5*INT(A5/B5)	3.090
12	120	=INT(A6/B6)&"."&A6-B6*INT(A6/B6)	0.012

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[deadlyduck]

Try this formula instead:

=INT(A2/B2)+MOD(A2,B2)/1000