Calculating minimum and maximum Price with different units

onexc · Jun 6th 2020

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.

**royUK** · Jun 6th 2020

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.

onexc · Jun 6th 2020

Thanks a lot Roy. This helps me.

**royUK** · Jun 6th 2020

Pleased to help

pal7mentor · Jun 19th 2020

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

**royUK** · Jun 20th 2020

pal7mentor:

Your answer does not really have anything to do with the question. I have deleted the link to your course and next time will ban you.

Share