Hello,
I'm trying to calculate the volume of a solution based on the mass, components, ratio of components and density.
I've entered formulas in column E, but would like a formula that can account for single or multiple components in the solution, as well as their respective ratios and densities.
I'd like to use column B to find the component, column C to find ratio of components and match those with column F and G to determine the density to be used in the calculation.
Thank you in advance for taking the time help me with this important problem.
I'm trying to calculate the volume of a solution based on the mass, components, ratio of components and density.
I've entered formulas in column E, but would like a formula that can account for single or multiple components in the solution, as well as their respective ratios and densities.
I'd like to use column B to find the component, column C to find ratio of components and match those with column F and G to determine the density to be used in the calculation.
Thank you in advance for taking the time help me with this important problem.
A (sample) | B (component/s) | C (component ratio) | D (mass (g)) | E (volume (ml)) | F (component) | G (density) |
solution1 | NotWater1:Water | 55:45 | 350 | =(D1*0.55/0.75)+(D1*0.45/1) | Water | 1 |
solution2 | NotWater2:NotWater1 | 83:17 | 423 | =(D2*0.83/0.96)+(D2*0.17/0.75) | NotWater1 | 0.75 |
solution3 | NotWater2 | 1 | 525 | =(D3*1/0.96) | NotWater2 | 0.96 |