Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I'm hoping somebody can help me with a little problem. The scenario is this: I'm playing an online game in which players are able to scout villages for resources, troops, etc. However, if the opposing player has x number of scouts present in their village, then y number of my scouts will be destroyed and the scouting attempt is detected. Attacking scouts have attack values (35 each) and defending scouts have defense values (20 each). For example: Is send 10 scouts (10 * 35 = 350), and in the defending village there are 2 scouts (2 * 20 = 40), so by using the formula ROUND(40*(40/350) ^1.5,0), I can see that I will lose two scouts. By sending 22 scouts would mean that all would survive and the scouting would be undetected. How can I 'reverse' this formula, so that by inputting a given number of defending scouts, I will never have any losses? I'm stumped! Any help would be much appreciated. Thanks Nige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking to reverse a quadratic formula, Sqrt and all?? | Excel Discussion (Misc queries) | |||
Reverse Fees Linear Formula | Excel Discussion (Misc queries) | |||
How do I create a reverse julian date formula? | Excel Worksheet Functions | |||
Is there an formula to reverse the order of a number sequence? | Excel Discussion (Misc queries) | |||
Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions |