LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking to reverse a quadratic formula, Sqrt and all?? DataSchemer Excel Discussion (Misc queries) 3 August 14th 09 02:36 PM
Reverse Fees Linear Formula Roddy Excel Discussion (Misc queries) 2 May 27th 08 09:20 PM
How do I create a reverse julian date formula? GaryM Excel Worksheet Functions 6 October 2nd 07 03:19 PM
Is there an formula to reverse the order of a number sequence? [email protected] Excel Discussion (Misc queries) 3 November 1st 06 04:47 PM
Need Formula or Function to calculate Margin (reverse of Percent a Ken Excel Worksheet Functions 1 February 7th 05 09:26 AM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"