Results 1 to 2 of 2

Math Help - Please help me make a quadratic equation spreadsheet

  1. #1
    Newbie
    Joined
    Jan 2010
    Posts
    16

    Please help me make a quadratic equation spreadsheet

    I'm learning quadratic equations

    I need practice solving them. I'm writing a spreadsheet so that I can get the correct answer.

    I'll use this spreadsheet to make problems with answers for me to practice on

    My spreadsheet can solve for x if a, b, and c are entered

    I'd like to

    solve a if x, b, and c are entered


    and


    solve b if x, a, and c are entered


    and


    solve c if x, a, and b are entered




    The cells in purple are what I need




    Edited
    I just figured out that my spreadsheet has a bug.

    I don't know how to take the square root of a negative number

    The cell in question is p15


    On the other stuff, it may not be possible. That's even better because my teacher won't ask these questions. (find c if x = 17)
    Attached Files Attached Files
    Last edited by rookie37; May 11th 2011 at 08:07 PM.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Aug 2007
    From
    USA
    Posts
    3,110
    Thanks
    2
    Solving for a, b, or c should be trivial. Solving for x isn't any harder than the Quadratic Formula, but you will need to check the intermediate result (descriminant) before finding the square root.

    Note: I'm not clicking your spreadsheet link. Show your formula in the text, here.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Excel Spreadsheet Problem
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: June 16th 2011, 08:14 AM
  2. Help w/ Excel spreadsheet & probability
    Posted in the Statistics Forum
    Replies: 1
    Last Post: May 19th 2010, 09:51 PM
  3. Spreadsheet equations
    Posted in the Advanced Algebra Forum
    Replies: 1
    Last Post: March 2nd 2010, 08:30 AM
  4. Need Blackjack Spreadsheet
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: January 27th 2010, 03:49 PM
  5. Spreadsheet help
    Posted in the Pre-Calculus Forum
    Replies: 0
    Last Post: October 28th 2008, 04:37 PM

Search Tags


/mathhelpforum @mathhelpforum