ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unrelated (https://www.excelbanter.com/excel-discussion-misc-queries/95570-unrelated.html)

capnsean

Unrelated
 

Maybe this question shouldn't be posted here, but I've always been given
great answers by some pretty bright people...so...

If I have a 37% solution of 'A'.

I need to make a solution with a final concentration of 1% by diluting
this with 'B'.


What's the math?


--
capnsean
------------------------------------------------------------------------
capnsean's Profile: http://www.excelforum.com/member.php...o&userid=25049
View this thread: http://www.excelforum.com/showthread...hreadid=554729


capnsean

Unrelated
 

an excel formula would be okay.

haha


seriously..


--
capnsean
------------------------------------------------------------------------
capnsean's Profile: http://www.excelforum.com/member.php...o&userid=25049
View this thread: http://www.excelforum.com/showthread...hreadid=554729


Owen

Unrelated
 
I think this should work

if A=1.37
B=1.00

x= parts of a
y= parts of b

1.37x + 1y = 1.01(x+y)

assume 1 part of x

1.37 + y = 1.01(1+y)
1.37 +y = 1.01 + 1.01y
..01y = .36

y = 36
x = 1



All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com