Results 1 to 3 of 3

Math Help - I need a simple formula for Excel

  1. #1
    Newbie
    Joined
    Nov 2012
    From
    Ohio
    Posts
    2

    I need a simple formula for Excel

    I need a simple formula for Excel that solves the following problem: A coal company has two grades of coal ALMA and BUCK. What is the least expensive mix ratio (percent) of the two coals which will net less than 11% ash and 2.7% sulfur. Use a simple ratio by weight of the two components to calculate the final properties.ALMA is 12.5% ash, 2.2% sulfur, and costs $40.00 per metric ton
    BUCK is 8.1% ash, 2.8% sulfur, and costs $50.00 per metric ton

    I don't even know where to start with this one. I may in the wrong section of the forum, so any direction someone can give me would be appreciated.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    4,166
    Thanks
    762

    Re: I need a simple formula for Excel

    Hey evenforyou.

    Instead of doing this for you, I will ask if you can first get the statement into mathematics and then the excel stuff can come later on.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Nov 2012
    From
    Ohio
    Posts
    2

    Re: I need a simple formula for Excel

    Hey chiro, thanks for the reply. I have an understanding of Algebra but that is as far as my math knowledge extends. I have tried to write an equation for the problem, but with all the variables I am totally at a loss. I don't have a clue where to start. Once I have an equation, I can probably turn it into an Excel statement, it's just figuring out the equation that is stumping me. Thank you for taking the time to respond.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 3
    Last Post: October 7th 2012, 01:16 AM
  2. excel statistic formula help
    Posted in the Statistics Forum
    Replies: 2
    Last Post: July 20th 2012, 04:58 AM
  3. need help with excel formula
    Posted in the Business Math Forum
    Replies: 5
    Last Post: August 31st 2009, 06:50 AM
  4. Replies: 4
    Last Post: May 19th 2009, 12:16 AM
  5. Looking for a Keyword ranking formula on a Data set in excel
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: April 7th 2009, 10:27 AM

Search Tags


/mathhelpforum @mathhelpforum