software

I was wondering if it is possible to make this query less longwinded?

=(IF(D17gt;0,(((A1-C17)/(A1/D17)) C17)) IF(E17gt;0,((A1-(((A1-C17)/(A1/D17)) C17))/(A1/E17)))) IF(F17gt;0,(A1-(((A1-C17)/(A1/D17) ((A1-(((A1-C17)/(A1/D17)) C17))/(A1/E17))) C17))/(A1/F17))A1= max value
C17=base value
D17,E17,F17= variable value's

I've been working on the Value for a Calc for a game I've been playing
lately.
I'm using it to work out damage resistances but I feel the formula
could be streamlined but for the life of me my brain has gone blank.
Example:
A1=100
C17 = 60
for arguments sake lets say D17, E17 and F17 are all = 30
the formula would get the max percentage and work out what the boosts
would be for each variable based on the difference between the max
value and the base value.
The answer given by the formula above for this would be 86.28

Does anyone know if there is a way to streamline the Formula? without
obviously using extra cells to store hidden values.

Rgds,
Kuda--
Kuda
------------------------------------------------------------------------
Kuda's Profile: www.excelforum.com/member.php...oamp;userid=31242
View this thread: www.excelforum.com/showthread...hreadid=5092741 What result are you expecting if lt;0 or =0? Your formula could return #NA!
Are trying to spread a value across periods?

quot;Kudaquot; wrote:

gt;
gt; I was wondering if it is possible to make this query less longwinded?
gt;
gt; =(IF(D17gt;0,(((A1-C17)/(A1/D17)) C17)) IF(E17gt;0,((A1-(((A1-C17)/(A1/D17)) C17))/(A1/E17)))) IF(F17gt;0,(A1-(((A1-C17)/(A1/D17) ((A1-(((A1-C17)/(A1/D17)) C17))/(A1/E17))) C17))/(A1/F17))
gt;
gt;
gt; A1= max value
gt; C17=base value
gt; D17,E17,F17= variable value's
gt;
gt; I've been working on the Value for a Calc for a game I've been playing
gt; lately.
gt; I'm using it to work out damage resistances but I feel the formula
gt; could be streamlined but for the life of me my brain has gone blank.
gt; Example:
gt; A1=100
gt; C17 = 60
gt; for arguments sake lets say D17, E17 and F17 are all = 30
gt; the formula would get the max percentage and work out what the boosts
gt; would be for each variable based on the difference between the max
gt; value and the base value.
gt; The answer given by the formula above for this would be 86.28
gt;
gt; Does anyone know if there is a way to streamline the Formula? without
gt; obviously using extra cells to store hidden values.
gt;
gt; Rgds,
gt; Kuda
gt;
gt;
gt; --
gt; Kuda
gt; ------------------------------------------------------------------------
gt; Kuda's Profile: www.excelforum.com/member.php...oamp;userid=31242
gt; View this thread: www.excelforum.com/showthread...hreadid=509274
gt;
gt;