a cube is a volume that is equal on all three sides (it has the same depth, height, and width) based on that, I've created an excel calculation that takes the dollar amount of bills, and uses the goalseek command to find the cubic size of the bills. since the bills themselves aren't cubic, I've added a calculation that returns the real size taken by the bills. (bold underline text is only for reference, and not a part of the equation)
A1 height width depth volume $1 =E3*1
size requested (in inches) B2 =B2 =B2 =D2*C2*B2 $2 =E3*2
number of bills =QUOTIENT(B2,0.0043) =QUOTIENT(C2,6) =QUOTIENT(D2,2.5) =D3*C3*B3 $5 =E3*5
actual size =B3*0.0043 =C3*6 =D3*2.5 =D4*C4*B4 $10 =E3*10
$20 =E3*20
$50 =E3*50
$100 =E3*100
to use this, you can provide an inch measurement in B2, and it will spit out how much will fill that cubic volume,
or you can goalseek in whatever dollar amount you want (by selecting the appropriate set cell in column G) and selecting B2 as the changing cell. alternatively, you can erase the HWD values in B2:D2 and use your own dimensions (e.g., 10 high, 20 wide, 15 deep)
Bookmarks