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.

[TABLE="width: 478"]
<colgroup><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Qnty[/TD]
[TD]SKU[/TD]
[TD]Formula[/TD]
[TD]Reqd Value[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]120[/TD]
[TD]=INT(A2/B2)&"."&A2-B2*INT(A2/B2)[/TD]
[TD]0.100[/TD]
[/TR]
[TR]
[TD]245[/TD]
[TD]120[/TD]
[TD]=INT(A3/B3)&"."&A3-B3*INT(A3/B3)[/TD]
[TD]2.005[/TD]
[/TR]
[TR]
[TD]356[/TD]
[TD]120[/TD]
[TD]=INT(A4/B4)&"."&A4-B4*INT(A4/B4)[/TD]
[TD]2.116[/TD]
[/TR]
[TR]
[TD]450[/TD]
[TD]120[/TD]
[TD]=INT(A5/B5)&"."&A5-B5*INT(A5/B5)[/TD]
[TD]3.090[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]120[/TD]
[TD]=INT(A6/B6)&"."&A6-B6*INT(A6/B6)[/TD]
[TD]0.012[/TD]
[/TR]
</tbody>[/TABLE]

 

[deadlyduck]

Try this formula instead:

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