=B1/A1 where A1 is your number ration to 1 and B is your litres of fuel
Or if you want the oil in ml =(B1/A1)*1000
Hi, my first post.
I am looking at ways to create my own fuel/oil mix calculator.
I know 50:1 is 100 Millilitres Oil to 5 Litres of Fuel.
Or, 20:1 is 250 Millitres Oil to 5 Litres of Fuel
There are various hard copy tables around or lables on oil containers showing the basic rounded figures only.
But I have no clue as to how the fomulae is in Excel so I can enter my own figures for various Fuel Ratio Oil mixes.
For example, I might require a 32:1 mix in 36.7 Litres of Fuel
My calculator would then calculate the exact amount of oil to mix in a 36.7 Litre container. (This is just an example, but the oil mixes MUST be accurate)
Can someone help with the formulae please ?
=B1/A1 where A1 is your number ration to 1 and B is your litres of fuel
Or if you want the oil in ml =(B1/A1)*1000
.select, overused and inefficient.
Welcome.
VERY simple.
cell A1 "Fuel:Oil Ratio"
cell A2 "20" This should be changed to suit the ratio you want.
cell B2 ":1"
cell A4 "Fuel"
cell B4 "Oil"
cell A5 "35" Or however many litres petrol
cell b5 "=A5/A2"
Thankyou,
I need 2 more formulaes please.
The other method percentages are used.
Some technical manuals define ratios in percents
So for example, 2 % oil to 1 Litre of fuel,
So if a cell asks to enter the value 1 (%), and we have 5 Litres of fuel, the answer ought to show 100 Millitres
How do I write that formulae ?
and
also a conversion from the basic calculation, that IF
a ratio of 50:1 is 100 Ml. of oil to 5 Litres of Fuel, then a formulae is required to calculate a sum to show the percent value.
I make it to be 1%
If Cell C2 is where I place your above formulae/s
In cell D2 I have put,
=C2/100 and get the answer 1.00 (%)
My ratio is 1 percent ?
This should complete my calculator.
Thanks in advance.
1)
=(A2*B2)*1000
Where A2 is litres of fuel and B2 is % (Incidentaly, the result is 50ml, not 100 in the example you gave)
2) 50:1 ratio would be 2%
If A3 is your ratio (50)
B3 is your litres of fuel (5)
C3 would be =(B3/A3)*1000 to show ml of oil
D3 would be =C3/(B3*1000) to show the percentage
.select, overused and inefficient.
Yep, typo stuff, npthe result is 50ml, not 100 in the example you gave)
Thanks Blade and Rob, I should ok from here with these basics.
Like this thread? Share it with others