12 point decimal system

  • Thread starter Thread starter Nick P
  • Start date Start date
N

Nick P

I inventory boxes of playing cards at work that contain 12 decks of cards in
box. Is there a way to add the nuber of decks (12) in a column that will
equal (1) box?

EX: Say I have added a column of decks up and the total is 50. I would
like the total to equal 4.2 (12 decks equals 1 box; 48 decks equals 4 boxes;
50 decks equals 4 boxes + 2 deck = 4.2 boxes)

Is this type of addition possible to achieve in excel?
 
This formula is not quite right. Say I have a total of 47 decks. This
would be 3 boxes of 12 (36) plus 11 decks. I would want my total to read
3.11 and your formula is reading 4.1
 
I inventory boxes of playing cards at work that contain 12 decks of cards in
box. Is there a way to add the nuber of decks (12) in a column that will
equal (1) box?

EX: Say I have added a column of decks up and the total is 50. I would
like the total to equal 4.2 (12 decks equals 1 box; 48 decks equals 4 boxes;
50 decks equals 4 boxes + 2 deck = 4.2 boxes)

Is this type of addition possible to achieve in excel?
Click to expand...

If you could express 50 as 4.02, then:

=INT(A1/12)+MOD(A1,12)/100

or if you have the Analysis ToolPak installed:

=dollarfr(A1/12,12)

If 50 must be expressed as 4.2, then:

=INT(A1/12)+MOD(A1,12)/10^(1+(MOD(A1,12)>=9))


--ron
 
If you could express 50 as 4.02, then:

=INT(A1/12)+MOD(A1,12)/100

or if you have the Analysis ToolPak installed:

=dollarfr(A1/12,12)

If 50 must be expressed as 4.2, then:

=INT(A1/12)+MOD(A1,12)/10^(1+(MOD(A1,12)>=9))


--ron
Click to expand...

The last formula is in error. Should be:

=INT(A1/12)+MOD(A1,12)/10^(1+(MOD(A1,12)>9))


--ron
 
Back
Top