If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel formula
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. |
#2
|
|||
|
|||
excel formula
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. |
#3
|
|||
|
|||
excel formula
I think that Bernard intended =A1-B1, not =A1-C1
-- David Biddulph "Bernard Liengme" wrote in message ... 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. |
#4
|
|||
|
|||
excel formula
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(C2C1,1,0) and in C3 =C1-C2+IF(C2C1,A1,0) More compact formulas would be =B1-B2-1*(C2C1) and =C1-C2+A1*(C2C1) respectively. On Sun, 4 Oct 2009 05:39:42 -0700 (PDT), Shankar G wrote: 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 |
Thread Tools | |
Display Modes | |
|
|