neuroscientia
New Member
- Joined
- Mar 22, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi, sorry of this is confusing.
Let me use an example to clarify.
I am making up a solution, e.g., 146ml. However I only own 50ml tubes, therefore the calculations used to make up the original would need to be altered so I could use multiple of my tubes. In this case I would make 4 x 37ml tubes of the solution (with corresponding concentrations), which would give me 148ml, which is more than I need which is OK (do not want less than I need).
Is there a way to do this as a formula on excel?
I have tried SUMIF, but the sum-range doesn't get me the information I need.
Thanks!
Let me use an example to clarify.
I am making up a solution, e.g., 146ml. However I only own 50ml tubes, therefore the calculations used to make up the original would need to be altered so I could use multiple of my tubes. In this case I would make 4 x 37ml tubes of the solution (with corresponding concentrations), which would give me 148ml, which is more than I need which is OK (do not want less than I need).
Is there a way to do this as a formula on excel?
I have tried SUMIF, but the sum-range doesn't get me the information I need.
Thanks!