weight formula

[veronic633]

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)

 

[RagDyer]

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!
==============================================



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)

 

[Jeff]

Veronica,
It's kinda hard to guess what you are trying to accomplish... i'll give
it a try.
I assume that you want to first calculate the weigh by giving number of
cards in Row1. Then Row 2 would be something like "=A1*8.5/1000"?

Jeff

 

[veronic633]

thats perfect! thanks so much

 

[Ragdyer]

Thanks for the feed-back.