excel formula

[Shankar G]

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.

 

[Bernard Liengme]

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

 

[David Biddulph]

I think that Bernard intended =A1-B1, not =A1-C1

 

[Tushar Mehta]

Think of basic subtraction. Suppose you want to subtract 19 from 37.
Because 9 > 7, we borrow 1 from the next position and subtract 9 from
17 to get 8. Because we borrowed 1 from the next position that
position becomes one less and the 3becomes 2 and subtracting 1 from 2
yields 1. So, we get the result 18.

Now, in this case if the packets to subtract > packets from, we borrow
not 10 units but 12 packets. The rest of the arithmetic remains the
same.

Suppose the #packets/case is in A1. Suppose the cases and packets in
hand are in B1 and C1 respectively. Finally, suppose the cases and
packets in the system are in B2 and C2 respectively.

Then, in B3 enter =B1-B2-IF(C2>C1,1,0) and in C3 =C1-C2+IF(C2>C1,A1,0)

More compact formulas would be =B1-B2-1*(C2>C1) and =C1-C2+A1*(C2>C1)
respectively.

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.

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins