Calculate Steel Pricing by hundredth weight (CWT)

Learn how to quickly calculate steel pricing by hundredth weight (CWT) using the following formula. For a quicker option, download the demonstration file.

To calculate the hundredth weight of steel pricing, you take the gross weight (40,000 lbs) multiplied by the pricing ($57.75) then divide by 100. This will provide you the overall coil price. You then take the gross weight divided by the overall price to give you a Price/lb.

Hundredth Weight

Leave a Reply

SUMIFS Function

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to

Read More »

RAND Function

The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel,

Read More »

NETWORKDAYS Function

The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically

Read More »
Scroll to Top