calulation need in excel?

Question

1box contains 12 pieces or 12 pieces equal to 1 box
When i have taken in company software shows 4 box 7 pieces. When I going for stock taking time I have found 2 box full (12 each box means 24 pieces of some item) 13 pieces. How I can subtract in excel this.
If I will subtract 4.7 – 2.13 excel give a result of 2.57 but real short is 1 box 6 pieces it should show. it should not put one column 4 and other column 7.
Any one can help to arrive this answer in excel or formula plz.

So far i did not get any correct answer plz help me any one

Answer 1

The difference is 18 boxes, which is 1 box + 6 pieces.
You have to do
=(4*12 + 7) - (2*12 + 13)
This will calculate as 55 - 37, or 18 pieces short.
You can then convert this to boxes + pieces like this:
Boxes (1):
= INT(((4*12+7) - (2*12+13))/12)
Pieces (6):
= MOD(((4*12+7) - (2*12+13)), 12)

Instead of the actual numbers, you might want to use the cell references. So if 4 and 7 are in B9 and C9, and 2 and 13 are in B10 and C10, you would have boxes:
= INT(((B9*12+C9) - (B10*12+C10))/12)
and pieces:
= MOD(((B9*12+C9) - (B10*12+C10)), 12)

Good luck.
.

Answer 2

One box - 12 Pieces

Your system shows 4 boxes and 7 pieces which means in number of pieces it should be (4x12) + 7 = 55

But the physical count shows only 2 boxes and 13 pieces (in pieces, (2x12) + 13 = 37

So in pieces the shortage is 55-37 = 18

in other words , 1 box and 6 pieces.

So in excel what you can do is show them in pieces rather than in boxes. For example

Balance as per the system (4x12) + 7 = 55
Balance as per physical count (2x12) + 13 = 37

Therefore shortage is (55-37) = 18

Divide this by 12 = 18/12 = 1.5 boxes - which means 1 box and 6 pieces

If you still need any clarification, just send me a mail

Answer 3

Perhaps the reason for your lack of answers is because your question is very confusing.

When you write "box" are you referring to a cell on an Excel sheet or an actual box of inventory at your place of work?

Your question needs to be rewritten in better English (if possible) for me to understand it...

Sorry!

Answer 4

Bhole Shankar here is your link

EXCEL CALCULATIONS

http://www.ozgrid.com/Excel/free-training/excel-lesson-25-basic.htm

Formulas

http://www.cpearson.com/excel/excelF.htm

Decision Models - The Excel Calculation Site

http://www.decisionmodels.com/index.htm

Answer 5

it particularly is basically a count number of the IF fact. this may be greater sensible in case you do no longer want to lose your numbers whilst calculating the sum of the beneficial and unfavourable numbers. a million. Create 2 greater columns. on the 1st column you created, on the cellular adjoining to the 1st variety, form this: IF([cellular variety]>0,[cellular variety],0) in simple terms replace the [cellular variety] annotations with that cellular variety. this might reveal all non-unfavourable numbers. click and drag the decrease-perfect nook of that cellular till the final variety. 2. Do the comparable for the 2nd column you created. This time, form IF([cellular variety]<0,[cellular variety],0) this might reveal all unfavourable numbers on your checklist. 3. After this, in simple terms place an autosum functionality on the tip of the checklist and you have calculated what you like. For greater, here is the source document i created to your question: desire it enables. The document has no virus, do no longer hardship.. :-)