# Thread: Completely forgotten complex formula transposition!

1. 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.

2.

3. 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)

4. 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.

 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   BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are On Terms of Use Agreement