Excel Help for a Numpty!

[barryuk99]

Hi All, I thought I was reasonably ok with using Excel, but have a total mental block with this seemingly simple issue!

I'm using Excel to calculate the percentage of a certain gas in a mixed gas input into a chamber.

So when inputting 10 Standard Litres per Min (SLPM) using a 5% to 95% gas mix. The 5% quantitiy in Standard Cubic Centimeters Meters (SCCM) can be calculated by using this Excel command
"=SUM(A2*1000/100)*5".

Now all I want to do is write a command line that will calculate how much I need to increase the 95% gas flow, to reduce the 5% gas flow to a 3% ratio mix.

I know that the answer to this is that the flow needs to increase to 16666 SCCM, but dont know how to write the Excel command?

Thanks in advance.

 

[barryuk99]

Many thanks for your response. There's some info I should have included. The 5/95% gas mix is fixed and I need to add an additional gas to reduce the ratio. So, using an Excel formula I'd like to calculate the addional gas required from a separate gas line.

 

[barryuk99]

MANY THANKS namnoc. That worked a treat.