Results 1 to 4 of 4

Quadratic Formula help in vba

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    15

    Quadratic Formula help in vba

    Hi Experts,

    I need some help to fix my Quadratic Equation in VBA. It looks fine except sqrt part.

    Here is the normal equation below X =

    -b +- √b^2-4(a)(c)
    ---------------------
    2(a)


    Here is my b value
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    b = (Range("C13") * Range("C14") / Range("C14") + vt * (xf - 1)
    Based on B my equation looks like this


    X = - Range("C13") * Range("C14") / Range("C14") + vt * (xf - 1) - Sqr(Range("C13") * Range("C14") / Range("C14") + vt) * (xf - 1) ^ 2 - 4 * ksp / 2

    It would be great if someone can give an idea on sqrt part. Beside that all seems to be working.

    Thanks,
    Vik
    Last edited by 6StringJazzer; 04-09-2014 at 10:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Quadratic Coefficients
    By Ian Adamson in forum Excel General
    Replies: 8
    Last Post: 05-07-2022, 10:06 AM
  2. Quadratic Equation in VBA
    By vop2311 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-09-2014, 10:19 PM
  3. quadratic equations help needed
    By Joseph Little in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2014, 10:25 AM
  4. Quadratic Regression - Help
    By kmr159 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-08-2013, 08:26 AM
  5. Quadratic equation
    By Nes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2005, 10:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1