large calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-2936915%22%20slang%3D%22en-US%22%3Elarge%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2936915%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20use%20excel%20to%20calculate%20something%20like%20this%2C%20if%20you%20are%20ordering%20containers%20of%20oil%20and%20you%20want%20to%20use%20excel%20to%20know%20exactly%20how%20much%20each%20liter%20of%20oil%20will%20cost%20you%3F%20if%209%20liters%20cost%20%2475%20and%20you%20want%20to%20buy%202%20tons%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2936915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2937162%22%20slang%3D%22en-US%22%3ERe%3A%20large%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2937162%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1210394%22%20target%3D%22_blank%22%3E%40mohamedali1%3C%2FA%3E%26nbsp%3B%20wrote%3A%20%60%60you%20are%20ordering%20containers%20of%20oil%20and%20%3CFONT%20color%3D%22%23FF0000%22%3Eyou%20want%3C%2FFONT%3E%20to%20use%20excel%20%3CFONT%20color%3D%22%23FF0000%22%3Eto%20know%3C%2FFONT%3E%20exactly%20%3CFONT%20color%3D%22%23FF0000%22%3Ehow%20much%20each%20liter%3C%2FFONT%3E%20of%20oil%20will%20cost%20you%3F%20if%20%3CFONT%20color%3D%22%23FF0000%22%3E9%20liters%20cost%20%2475%3C%2FFONT%3E%20and%20you%20want%20to%20buy%202%20tons%60%60%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESounds%20like%20a%20class%20assignment%20or%20test%20question.%26nbsp%3B%20So%2C%20I%20can%20only%20offer%20some%20guidance%2C%20not%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20your%20question%20does%20not%20make%20sense.%26nbsp%3B%20But%20perhaps%20on%20purpose.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20know%20how%20much%209%20liters%20cost%2C%20you%20can%20calculate%20cost%20per%20liter%20directly%20from%20those%20facts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20has%20nothing%20to%20do%20with%20%22and%20you%20want%20to%20buy%202%20tons%22.%26nbsp%3B%20And%20maybe%20that's%20the%20point%20of%20the%20%22trick%20question%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-----%3C%2FP%3E%3CP%3EOTOH%2C%20a%3CFONT%20color%3D%22%23000000%22%3Ere%20you%20really%20asking%3A%3C%2FFONT%3E%3CFONT%20color%3D%22%23FF0000%22%3E%26nbsp%3B%20%60%60if%209%20liters%20costs%20%2475%2C%20how%20much%20does%202%20(metric%3F)%20tons%20cost%3F%60%60%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20that%20case%2C%20we%20need%20to%20know%20the%20following%3A%3C%2FP%3E%3CP%3E1.%20How%20much%20does%20a%20liter%20cost%3F%3C%2FP%3E%3CP%3E2.%20How%20much%20does%20a%20liter%20of%20%3CFONT%20color%3D%22%23FF0000%22%3E(crude%3F)%3C%2FFONT%3E%20oil%20weigh%3F%26nbsp%3B%20Try%20a%20google%20search%3C%2FP%3E%3CP%3E3.%20How%20many%20kg%20in%20a%20%3CFONT%20color%3D%22%23FF0000%22%3E(metric%3F)%3C%2FFONT%3E%20ton%3F%26nbsp%3B%20Try%20a%20google%20search%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20the%20required%20number%20of%20tons%20(2)%20times%20kg-per-ton%20converts%20to%20required%20number%20of%20kg.%26nbsp%3B%20Divided%20by%20kg-per-liter%20of%20crude%20oil%20converts%20to%20required%20number%20of%20liters.%26nbsp%3B%20And%20multiplied%20by%20cost-per-liter%20calculates%20total%20cost.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-----%3C%2FP%3E%3CP%3EHowever%2C%20you%20said%20that%20your%20are%20ordering%20%22containers%22%20of%20oil.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that%20is%20the%20case%2C%20we%20must%20round%20up%20the%20(minimum)%20number%20of%20liters%20to%20a%20multiple%20of%20liters-per-container.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20that%2C%20we%20also%20need%20to%20know%3A%26nbsp%3B%20how%20many%20liters%20(of%20crude%20oil)%20fit%20in%20each%20container%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(The%20viscosity%20of%20the%20liquid%20--%20crude%20oil%20--%20might%20be%20a%20factor.%26nbsp%3B%20But%20let's%20ignore%20that.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20to%20a%20wikipage%20found%20with%20a%20google%20search%3A%26nbsp%3B%20%60%60International%20standard%20size%20%2F%20%5B....%5D%20The%20exact%20capacity%20varies%20by%20manufacturer%2C%20purpose%2C%20or%20other%20factors.%20Standard%20drums%20have%20inside%20dimensions%20%5Bthat%5D%20yield%20a%20volume%20of%20about%20218.7%20litres%20%5B...%5D%2C%20but%20they%20are%20commonly%20filled%20to%20about%20200%20litres.%60%60%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20use%20the%20CEILING%20function%20to%20round%20up%20the%20number%20of%20liters%20for%202%20tons%20of%20crude%20oil%20to%20a%20multiple%20of%20liters-per-container.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello All,

Is there a way to use excel to calculate something like this, if you are ordering containers of oil and you want to use excel to know exactly how much each liter of oil will cost you? if 9 liters cost $75 and you want to buy 2 tons 

1 Reply

@mohamedali1 

 

=(75/9)*2000

 

Sample file is attached.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)