by Guest » Tue Mar 08, 2016 8:51 pm
What we ended up with was an equation balancing the salt before and the salt after.
0.04 x 75 = X(75 + 45)
You have a calculation to do on the LHS and a calculation to do on the RHS
Normally you would do this on your calculator in stages and end up with..... 3 = 120X ...so X = 3/120 etc
OR re-arrange to get the unknown X on one side ..... X = (0.04 x 75)/(75+45) and do this on you calculator and you would end up with the same 3/120 = 1/40 = 2.5%
You could do the same calculations on a spreadsheet by putting the the re-arranged calculations in cells.....
In A2 put in as a heading...... Final Percent Salt
In A3 below it put in.......... =(0.04 x 75)/(75+45)x100
Multiply by 100 so as to display answer as percent OR format cell %
Don't forget the = sign at start of all formulas.
That will give the answer in one operation.
If you want a table as was the last question showing the percentage salt for each row against each lb of water added.....
In cell A1 put heading "lbs water added" and in B1 put heading " Percent Salt"
Fill series down column A from A2 down with the numbers 1 to 50 say....
In B2 put in the formula.... =(0.04 x 75)/(75+A2)x100
Copy this formula down column B alongside the numbers you filled in A
The reference "A2" in the formula will change automatically to "A3" then "A4" etc in each row as it is copied down.
So the formula will work out the percent for each row corresponding to the number in the cell in the A column.
When you come to the row with 45 lbs added you should see 2.5% in column B on that row.