-
Percent
Hi,
I am trying to test a formula. Normally, I enter my weight and my excel spread sheet (or other software) calculates the percentage.
Does anyone know the trick to entering the Percent amount for each ingredient/item and then given the weight? It’s probably so simple I am over looking it. So basically I want to enter given percentage and be given the weight. -
6 Replies
-
@Kfox - Just multiply the size of the batch by the % and divide by 100.
500 g batch, 5% of the ingredient = 5*500/100 = 25gThe Khan Academy is an excellent source too. -
You really, really need to take the time to master the concept of percentages - it’s critically important.
You can set up your excel spreadsheet in percent. This simplifies the formula you need to use.
Example:A B1 Water 70%2 Fragrance 10%3 Alcohol 20%4 Total 100% -
Next, enter your batch size (without units) in a new cell: (I usually insert a row on top)A B1 Batch Size 5002 Water 70%3 Fragrance 10%4 Alcohol 20%5 Total 100%Finally, you need to enter the formula in Column C, which is (Batch Size)*(% of ingredient in formula). Excel lets you refer to cells when you put in a formula, so you don’t have to enter the formula numbers again.Example: (I’m showing the formula, not the results that you’ll see after you enter it)A B C1 Batch Size 500 Weights:2 Water 70% =B1*B23 Fragrance 10% =B1*B34 Alcohol 20% =B1*B45 Total 100%
-
Finished spreadsheet: (500 gram batch size)A B C1 Batch Size 500 Weights:2 Water 70% 350.003 Fragrance 10% 50.004 Alcohol 20% 100.005 Total 100%The total of the weights in Column C should match the batch size you entered in Column B. (Cell B1)
-
Thank you, got it! Just trying to master the excel formula for testing. I use the row and column formula and also set up the scale formula. Love excel!
It was so easy, I missed the tree looking through the forest…lol
Log in to reply.