• Percent

    Posted by JD on September 14, 2014 at 1:33 pm

    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.

    JD replied 9 years, 6 months ago 3 Members · 6 Replies
  • 6 Replies
  • bobzchemist

    Member
    September 14, 2014 at 5:50 pm
  • oldperry

    Member
    September 15, 2014 at 8:54 am

    @Kfox - Just multiply the size of the batch by the % and divide by 100.

    500 g batch, 5% of the ingredient = 5*500/100 = 25g
    The Khan Academy is an excellent source too.
  • bobzchemist

    Member
    September 15, 2014 at 10:01 am
    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 B
    1 Water 70%
    2 Fragrance 10%
    3 Alcohol 20%
    4 Total 100%
  • bobzchemist

    Member
    September 15, 2014 at 10:13 am
    Next, enter your batch size (without units) in a new cell: (I usually insert a row on top) 
    A B
    1 Batch Size 500
    2 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 C
    1 Batch Size 500 Weights:
    2 Water 70% =B1*B2
    3 Fragrance 10% =B1*B3
    4 Alcohol 20% =B1*B4
    5 Total 100%
  • bobzchemist

    Member
    September 15, 2014 at 10:15 am
    Finished spreadsheet: (500 gram batch size)

    A B C
    1 Batch Size 500 Weights:
    2 Water 70% 350.00
    3 Fragrance 10% 50.00
    4 Alcohol 20% 100.00
    5 Total 100%

    The total of the weights in Column C should match the batch size you entered in Column B. (Cell B1)
  • JD

    Member
    September 26, 2014 at 12:29 am

    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.