Notices
Results 1 to 3 of 3

Thread: Completely forgotten complex formula transposition!

  1. #1 Completely forgotten complex formula transposition! 
    New Member
    Join Date
    Feb 2013
    Posts
    2
    It has been a good 16 years since I finished highschool, after which point I haven't studied any further maths. Hopefully this is an easy question for someone who has kept up with their algebra better!

    I am trying to write a spreadsheet for a game I play, one cell of which I need to display a specific value following this formula:

    D*(1-((A/(A+(12*D)))))=H

    D = damage
    A = armor
    H = health

    Essentially, I need to rewrite the formula to solve for D, given values of A and H. From a conceptual point of view, I want to know the maximum value of damage you can take (D) given a certain level of armor (A) before you run out of health (H). I can work out discrete values at specific points, but I can't for the life of me transpose the formula to use in excel.

    Thanks in advance for any help you can give me!


    Reply With Quote  
     

  2.  
     

  3. #2  
    Brassica oleracea Strange's Avatar
    Join Date
    Oct 2011
    Location
    喫茶店
    Posts
    17,036
    Here you go, get a computer to do the hard work: solve D*(1-((A/(A+(12*D)) )))=H for D - Wolfram|Alpha

    (I haven't checked that it has interpreted it correctly, but it looks reasonable at first glance)


    ei incumbit probatio qui dicit, non qui negat
    Reply With Quote  
     

  4. #3  
    New Member
    Join Date
    Feb 2013
    Posts
    2
    Thanks for the link.. after about half an hour of scratching my head, I finally managed to get them into a form that gives me the expected output in excel! I don't feel so bad about not being able to work out how to do it now, the formulas it came up with are just.. crazy.
    Reply With Quote  
     

Similar Threads

  1. Transposition of Formula
    By Quantime in forum Mathematics
    Replies: 14
    Last Post: November 18th, 2012, 03:19 PM
  2. Transposition of equation
    By Sindrato in forum Mathematics
    Replies: 6
    Last Post: October 15th, 2010, 08:12 PM
  3. complex numbers, and complex planes
    By Heinsbergrelatz in forum Mathematics
    Replies: 14
    Last Post: December 3rd, 2009, 08:19 PM
  4. forgotten logic question
    By Arcane_Mathematician in forum General Discussion
    Replies: 23
    Last Post: July 5th, 2009, 06:47 PM
  5. Failures and Forgotten Ideas in Science
    By Sullivan in forum General Discussion
    Replies: 2
    Last Post: March 24th, 2009, 12:03 PM
Bookmarks
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
  •