I've added an option where you can select the unit of measurement for the powder from a dropdown box. You can enter kilograms, grams or pounds.
The link is the same -
https://www.dropbox.com/s/qx02amlb5at33 ... .xlsx?dl=0And in case you're wondering how it calculates the end result, here's the formula!
=IF(C8>0,IF(C3>0,(E3/C3),0)+IF(C4>0,(E4/C4),0)+IF(C5>0,(E5/C5),0)+IF(B6="grams",(E6/(C6/(C8*0.0647989))),0)+IF(B6="kilograms",(E6/(C6/(C8*0.0000647989))),0)+IF(B6="pounds",(E6/(C6/(C8*0.000142857))),0),0)