12 point decimal system

[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?

 

[Ed Ferrero]

Hi Nick,

If A1 = 50

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

= 4.2

 

[Nick P]

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

 

[Arvi Laanemets]

Hi

=VALUE(INT(A1/12)&"."&MOD(A1,12))

Arvi Laanemets

 

[Chip Pearson]

You can use the DOLLERDE and DOLLARFR functions to do this sort of
thing. See help and www.cpearson.com/excel/fractional.htm for more
information.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Ron Rosenfeld]

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?

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

 

[Ron Rosenfeld]

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

The last formula is in error. Should be:

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


--ron