Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to streamline this Formula?
I was wondering if it is possible to make this query less longwinded? =(IF(D170,(((A1-C17)/(A1/D17))+C17))+IF(E170,((A1-(((A1-C17)/(A1/D17))+C17))/(A1/E17))))+IF(F170,(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: http://www.excelforum.com/member.php...o&userid=31242 View this thread: http://www.excelforum.com/showthread...hreadid=509274 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to streamline this Formula?
1 What result are you expecting if <0 or =0? Your formula could return #NA!
Are trying to spread a value across periods? "Kuda" wrote: I was wondering if it is possible to make this query less longwinded? =(IF(D170,(((A1-C17)/(A1/D17))+C17))+IF(E170,((A1-(((A1-C17)/(A1/D17))+C17))/(A1/E17))))+IF(F170,(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: http://www.excelforum.com/member.php...o&userid=31242 View this thread: http://www.excelforum.com/showthread...hreadid=509274 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |