I cannot make any sense of your numbers but:

If in A1 I enter 383 (number of packet)
Then in B1 I can use =INT(A1/12) to compute 31 cases
And in C1 either =A1-C1 or MOD(A1,12) to compute 10 remaining packets
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Shankar G" wrote in message
...
1 case equel to 12 packets.
In my system shows 215 case and 11 packet. My hand i have 247 case and
9 packets.
How i can make a excel formula and result should show 31 case and 10
packets.
in my excel sheets shows 31.9899 shows.
any one help me to slove.