Thread: Completely forgotten complex formula transposition!

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!

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)

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.