This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
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
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)