Formula to convert price per foot to price per CWT?

For whatever reason I can't wrap my head around how to come up with a formula to convert price per foot to price per hundredweight.

 Description WT/FT $/FT $/CWT
Product 6.16 $21.07 ???

I don't have a problem adding another column if I need to.

Can anyone help?

Regards,

Nanci 

 

Re:  convert price per foot to price per 100 lbs

100/6.16 = Feet per 100 lbs (16.2338)
16.2338 * $21.07 = Price per 100 lbs ($342.05)

'---
Jim Cone
Portland, Oregon USA
https://www.dropbox.com/sh/ttybwg5e9r31twa/AAAnyBTHPX5XsTDp10ItTcw4a?dl=0
(free & commercial excel programs)

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

100/6.16 gives you number of feet in 100lbs

Feet * 21.07 gives you total price

In D2 enter  =100/6.16*21.07

I get   $342.05

Gord

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 14, 2024 Views 4,661 Applies to: