 # Calculating minimum and maximum Price with different units

• Hello,

I am trying to calculate minimum and maximum quantity price per items for a tender offer. My problem is there are different metrics in my Excel sheet. It is easy to calculate prices per items because they are simply quantities. However, when it comes to cubic meters, I do not know where to begin. For instance, what is one item/unit price for 1.3 tonnes. If I divide 5,000 dollars to 1.3, the result is 3.846 . Seemingly this is not what is desired as a unit price. Any help would be appreciated.

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• 3.846 is the cost per kilo. A cubic metre conversion depends on the density of the product.

Quote

Divide the mass in kilograms by the density in kilograms per cubic meter to obtain the volume in cubic meters. For one ton of gold, the calculation is 1,000 kg/(19,300 kg/m^3) = 0.05 cubic meters.

• Thanks a lot Roy. This helps me.

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• You need to find which products have the smallest and largest demand. This is a small list, but if you sell or resell a lot of product, the following formula can be invaluable. You can find minimum and maximum units easily with the MIN() and MAX() functions.

• In cell B15, type “=MIN(C2:C13)”.
• In cell B16, type “=MAX(C2:C13)”.

regards