Weight & volume

[Richard]

Sorry, My first post didn't take. If A1 has a weight lets say 1 1/2 lbs.
and B1 is 10% water. Whats the results in C1? Thanks in advance!

 

[JLatham]

If you mean that given a weight in A1, and a % value in B1 that represents
how much of A1 is a certain material (as water), then
=A1 * B1 will tell you how much of the weight of A1 is water
or
=A1 - (A1*B1)
will tell you how much of the weight in A1 is NOT water.

So far none of this has anything to do with volume.

 

[JLatham]

I agree. I didn't even want to bring up things like specific gravity, or
relative weights of components without consideration for volume. i.e., an
item (who knows what it would be) made 50/50 by weight of lead and styrofoam
would have grossly different ratio when based on volume.