How to reverse an Excel formula?
 

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

How to reverse an Excel formula?
 

=ROUNDUP((A2*20/((0.5/(A2*20))^(2/3)))/35,0)
--
David Biddulph

"Nige" wrote in message
...
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

How to reverse an Excel formula?
 

David

Many thanks for the speedy reply - and a double thank you for the
excellent formula.

Thanks again

Nige
On 4 Dec, 12:56, "David Biddulph" <groups [at] biddulph.org.uk wrote:
=ROUNDUP((A2*20/((0.5/(A2*20))^(2/3)))/35,0)
--
David Biddulph

"Nige" wrote in message

...



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- Hide quoted text -

- Show quoted text -