I need help to get dozens and units separate subtraction

[SilverChat]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: right"]AVAILABLE
[/TD]
[TD]DATA
[/TD]
[TD="align: right"]SALE
[/TD]
[TD]DATA
[/TD]
[TD="align: right"]REMAINING
[/TD]
[TD]DATA
[/TD]
[/TR]
[TR]
[TD="align: center"]DOZENS
[/TD]
[TD="align: center"]UNITS
[/TD]
[TD="align: center"]DOZENS
[/TD]
[TD="align: center"]UNITS
[/TD]
[TD="align: center"]DOZENS
[/TD]
[TD="align: center"]UNITS
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]6
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]9
[/TD]
[/TR]
</tbody>[/TABLE]

Hi, every one please help me out on this....
I have to make the table in which these are the columns and rows where Available data is the stock available and sale data is the one which i want to insert manually but remaining data will automatically be calculated,
for suppose I have available data dozens and units I have sold dozens and units now the remaining data will automatically be subtracted from available data....

 

[clabulis]

If I understand your question correctly, and assuming the table above represents columns A through F, put this in column E:
=INT(((A3*12+B3)-(C3*12+D3))/12)

And put this in Column F:
=MOD((A3*12+B3)-(C3*12+D3),12)

 

[yshridhar]

A3,B3 available C3, D3 sale E3, F3 remaining
E3 (dozens) =QUOTIENT(((A3*12)+B3)-(C3*12+D3),12)
F3 (units) =MOD(((A3*12)+B3)-(C3*12+D3),12)

 

[SilverChat]

clabulis and yshridhar Thanks alot both of you....
Thanks it worked.....
GOD BLESS YOU

<link href="chrome://s3gt/skin/s3gt_tooltip.css" type="text/css" rel="stylesheet">

 

[SilverChat]

what if i want to add carton column then what would be the formula.

 

[yshridhar]

Remaining
cartons (8) =QUOTIENT((SUM(A3*72,B3*12,C3)-SUM(D3*72,E3*12,F3)),72)
dozens (4 not 10) =QUOTIENT(MOD((SUM(A3*72,B3*12,C3)-SUM(D3*72,E3*12,F3)),72),12)
units (4) =MOD((SUM(A3*72,B3*12,C3)-SUM(D3*72,E3*12,F3)),12)

regards
sridhar

 

[mikerickson]

Cartons =A12-D12-(E12>B12)
Dozens =MOD(B12-E12-(F12>C12) ,6)
Units =MOD(C12-F12, 12)

Or , to return the values for a-b

Units = MOD(aUnits-bUnits, 12)
Dozens = MOD(aDozens - bDozens -(bUnits>aUnits), 6)
Cartons = aCartons - bCartons - (bDozens>aDozens)

 

[SilverChat]

yshridhar andmikerickson
thanks a lot.....