Hey there! Sign in to join this conversationNew here? Join for free

Can microsoft excel 2010 operate with imaginary/complex numbers? Watch

    • Thread Starter
    Offline

    1
    ReputationRep:
    Im doing a bit of coursework and I need to solve a quadratic equation with no real solutions. Can excel do this?

    Thanks!
    Offline

    2
    ReputationRep:
    (Original post by Kaya_01)
    Im doing a bit of coursework and I need to solve a quadratic equation with no real solutions. Can excel do this?

    Thanks!
    Why can't you do it by hand? It's usually much quicker and clearer than trying to input it on a computer.
    • Thread Starter
    Offline

    1
    ReputationRep:
    (Original post by dknt)
    Why can't you do it by hand? It's usually much quicker and clearer than trying to input it on a computer.
    I forgot to add that its a must that I use excel to solve the equation.
    Offline

    12
    ReputationRep:
    (Original post by Kaya_01)
    I forgot to add that its a must that I use excel to solve the equation.
    Why don't use just try it and see? Or just try and root a negative number and see what happens!
    Offline

    1
    ReputationRep:
    http://www.wisc-online.com/objects/V...spx?ID=eng5603

    That has a walkthrough. No idea if its right, was just the first search result on google.
    • Thread Starter
    Offline

    1
    ReputationRep:
    (Original post by Freerider101)
    Why don't use just try it and see? Or just try and root a negative number and see what happens!
    I did, i got the result 'NUM!' indicating that its not possible to work with imaginary numbers
    • Thread Starter
    Offline

    1
    ReputationRep:
    (Original post by scott8anthony)
    It can, which I only just found out! :o: Just put 'imsqrt' and I think it'll work in the equation even if b squared is greater than 4ac, but because it's iterative (and excel) it's not brilliant; it told me the square root of minus 9 had a real component to the order of ten to the minus 16.
    Thank You! you have no idea how much that helps!
    • Community Assistant
    Offline

    19
    ReputationRep:
    (Original post by Kaya_01)
    Im doing a bit of coursework and I need to solve a quadratic equation with no real solutions. Can excel do this?

    Thanks!
    I have no idea whether Excel can cope with complex numbers or not but surely it should only take a few minutes to knock up a spreadsheet that takes the discriminant and tests whether it is >= 0. If it is, solve in the normal way. If not just work through the various parts of the quadratic formula separately.
    • Thread Starter
    Offline

    1
    ReputationRep:
    (Original post by scott8anthony)
    It can, which I only just found out! :o: Just put 'imsqrt' and I think it'll work in the equation even if b squared is greater than 4ac, but because it's iterative (and excel) it's not brilliant; it told me the square root of minus 9 had a real component to the order of ten to the minus 16.
    I keep getting a value that is multiplied by 'E - 16', and then my complex number.
    Do you have to play around with the settings?
    Offline

    1
    ReputationRep:
    (Original post by Kaya_01)
    I keep getting a value that is multiplied by 'E - 16', and then my complex number.
    Do you have to play around with the settings?
    if its the same every time, just multiply everything by 10^16 I think
    Offline

    0
    ReputationRep:
    The Answer to the question is a definite yes.

    The URL may be a bit dated as it refers to Excel 2003, but worth a look as Excel won't have dropped these functions:

    http://office.microsoft.com/en-us/ex...005209120.aspx

    http://office.microsoft.com/en-us/ex...019.aspx?CTT=1

    Otherwise if you are really brave you could get yourself Visual Studio 2010 and write your own XLL function call. If you can do that before you got to Unviersity, you'll certainly be in line for £250k PA Quant job in an investment bank.
    Offline

    3
    ReputationRep:
    (Original post by Kaya_01)
    Im doing a bit of coursework and I need to solve a quadratic equation with no real solutions. Can excel do this?

    Thanks!
    Yes it can.
    You can find these type of function in the 'planning' or engineering function cathegory
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Did TEF Bronze Award affect your UCAS choices?
    Useful resources

    Make your revision easier

    Maths

    Maths Forum posting guidelines

    Not sure where to post? Read the updated guidelines here

    Equations

    How to use LaTex

    Writing equations the easy way

    Student revising

    Study habits of A* students

    Top tips from students who have already aced their exams

    Study Planner

    Create your own Study Planner

    Never miss a deadline again

    Polling station sign

    Thinking about a maths degree?

    Chat with other maths applicants

    Can you help? Study help unanswered threads

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.