Why would you need a chart?

Enter the number of cards in A1.
Enter this formula in B1 to get your answer:

=A1/1000*8.5&" Lbs."

OR
If you would prefer pounds and ounces, enter this in B1:
=INT(A1/1000*8.5)&" Lbs."&MOD(A1/1000*136,16)&" oz."
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



wrote in message
oups.com...
Hi, I feel so stupid because this is such an easy formula. Its just my
brain isn't working lately (been sick) and its driving me crazy.
Anyway, this is the problem
A1 = number of cards
A2 = how many pounds the cards weigh
1,000 cards = 8.5 pounds
So if I have 1400 cards that would be like 11 pounds.
So I need to make an ongoing chart of this.
Please help! :) thanks so much. (I hope that made sense)