SOLVED

help for setting up a formula to calculate monster evolving in Summoners War

%3CLINGO-SUB%20id%3D%22lingo-sub-1156027%22%20slang%3D%22en-US%22%3Ehelp%20for%20setting%20up%20a%20formula%20to%20calculate%20monster%20evolving%20in%20Summoners%20War%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156027%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20want%20to%20make%20an%20excel%20file%20that%20I%20can%20use%20to%20calculate%20how%20many%20units%20I%20can%20evolve.%3CBR%20%2F%3EBasic%20info%3A%3CBR%20%2F%3Efor%20a%202*%20(2%20star)%20unit%20to%20evolve%2C%20it%20needs%20to%20be%20max%20level%2C%20and%20needs%202%20other%202*%20units%20(of%20any%20level)%20to%20become%20a%203*%20unit%3CBR%20%2F%3Efor%20a%203*%20(3%20star)%20unit%20to%20evolve%2C%20it%20needs%20to%20be%20max%20level%2C%20and%20needs%203%20other%203*%20units%20(of%20any%20level)%20to%20become%20a%204*%20unit%3CBR%20%2F%3E%3CBR%20%2F%3Ehow%20I%20want%20the%20excel%20to%20work%20is%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3EA1%20here%20I%20type%20in%20the%20ammount%20of%202*%20units%20I%20have%3CBR%20%2F%3EA2%20here%20is%20the%20formula%20for%20how%20many%202*%20max%20level%20units%20I%20need%20to%20evolve%20those%20units%3C%2FP%3E%3CP%3EA3%20here%20is%20the%20formula%20for%20how%20many%203*%20I%20will%20get%20from%20that%3CBR%20%2F%3EB1%20here%20I%20type%20in%20the%20ammount%20of%203*%20units%20I%20have%3CBR%20%2F%3EB2%20here%20is%20the%20formula%20for%20how%20many%203*%20mac%20level%20units%20I%20need%20to%20evolve%20the%203*%20units%20I%20have%20typed%20into%20B1%2C%20and%20taking%20the%20ammount%20of%203*%20units%20I%20got%20from%20evolving%202*%20units%20in%20A3%3CBR%20%2F%3EB3%20here%20is%20the%20formula%20of%20how%20many%204*%20units%20I%20will%20get%20from%20that%3CBR%20%2F%3E%3CBR%20%2F%3EI%20will%20also%20be%20having%20a%20formula%20for%204*%20into%205*%20but%20that%20one%20I%20is%20similar%20to%20the%203*%20one%2C%20so%20I'll%20be%20copy%20pasting%20that%20formula%20and%20adjust%20it%20for%204*%20instead%20of%203*%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20basic%20excel%20knowledge%20from%20school%2C%20and%20using%20it%20for%20simple%20things%20from%20now%20and%20then%3CBR%20%2F%3EI%20know%20how%20to%20use%20the%20standard%20commands%20like%20multiplying%2C%20adding%20multiple%20numbers%20together%20and%20so%20on.%3CBR%20%2F%3EI%20do%20not%20know%20how%20to%20make%20advanced%20formulas%20like%20I%20am%20trying%20to%20do%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1156027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1156071%22%20slang%3D%22en-US%22%3ERe%3A%20help%20for%20setting%20up%20a%20formula%20to%20calculate%20monster%20evolving%20in%20Summoners%20War%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F547622%22%20target%3D%22_blank%22%3E%40RoxyWolf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELemme%20see%20if%20I%20have%20this%20right...%3C%2FP%3E%3CP%3ESay%20you%20have%208%202*%20(non-maxed)%2C%205%202*%20(maxed)%2C%206%203*%20(non-maxed)%2C%206%203*%20(maxed)%3C%2FP%3E%3CP%3EA1%20%3D%208%3C%2FP%3E%3CP%3EB1%20%3D%205%3C%2FP%3E%3CP%3EC1%20%3D%20MIN(B1%2CINT(A1%2F2))%20%5BYou%20can%20evolve%20all%20your%20maxed%202*%20or%20any%20that%20you%20have%202X%202*%20non-maxed)%3C%2FP%3E%3CP%3EA2%20%3D%206%3C%2FP%3E%3CP%3EB2%20%3D%206%3C%2FP%3E%3CP%3EC2%20%3D%26nbsp%3BMIN(B2%2CINT((A2%2BC1)%2F3))%20%5BYou%20can%20evolve%20all%20maxed%203*%20or%20any%20that%20you%20have%203X%203*%20non-maxed).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1156077%22%20slang%3D%22en-US%22%3ERe%3A%20help%20for%20setting%20up%20a%20formula%20to%20calculate%20monster%20evolving%20in%20Summoners%20War%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F462348%22%20target%3D%22_blank%22%3E%40macrordinary%3C%2FA%3E%26nbsp%3Bputting%20in%20this%20info%20makes%20C1%20and%20C2%20say%20%23NAVN%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1156152%22%20slang%3D%22en-US%22%3ERe%3A%20help%20for%20setting%20up%20a%20formula%20to%20calculate%20monster%20evolving%20in%20Summoners%20War%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156152%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20the%20solution%20myself.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EA1%208%3CBR%20%2F%3EB1%20%3DRounddown(A1%2F2%2C0)%3C%2FP%3E%3CP%3EA2%206%3C%2FP%3E%3CP%3EB2%20%3DRounddown(A2%2BB1%2F3%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20was%20a%20bit%20simpler%20than%20I%20thought%20it%20would%20be%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi. I want to make an excel file that I can use to calculate how many units I can evolve.
Basic info:
for a 2* (2 star) unit to evolve, it needs to be max level, and needs 2 other 2* units (of any level) to become a 3* unit
for a 3* (3 star) unit to evolve, it needs to be max level, and needs 3 other 3* units (of any level) to become a 4* unit

how I want the excel to work is like this:

A1 here I type in the ammount of 2* units I have
A2 here is the formula for how many 2* max level units I need to evolve those units

A3 here is the formula for how many 3* I will get from that
B1 here I type in the ammount of 3* units I have
B2 here is the formula for how many 3* mac level units I need to evolve the 3* units I have typed into B1, and taking the ammount of 3* units I got from evolving 2* units in A3
B3 here is the formula of how many 4* units I will get from that

I will also be having a formula for 4* into 5* but that one I is similar to the 3* one, so I'll be copy pasting that formula and adjust it for 4* instead of 3*

I have basic excel knowledge from school, and using it for simple things from now and then
I know how to use the standard commands like multiplying, adding multiple numbers together and so on.
I do not know how to make advanced formulas like I am trying to do now

3 Replies
Highlighted

@RoxyWolf 

 

Lemme see if I have this right...

Say you have 8 2* (non-maxed), 5 2* (maxed), 6 3* (non-maxed), 6 3* (maxed)

A1 = 8

B1 = 5

C1 = MIN(B1,INT(A1/2)) [You can evolve all your maxed 2* or any that you have 2X 2* non-maxed)

A2 = 6

B2 = 6

C2 = MIN(B2,INT((A2+C1)/3)) [You can evolve all maxed 3* or any that you have 3X 3* non-maxed).

 

Highlighted

@macrordinary putting in this info makes C1 and C2 say #NAVN?

Highlighted
Best Response confirmed by RoxyWolf (New Contributor)
Solution

I found the solution myself. 

A1 8
B1 =Rounddown(A1/2,0)

A2 6

B2 =Rounddown(A2+B1/3,0)

 

 

it was a bit simpler than I thought it would be