SOLVED

Highlighted
New Contributor

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

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

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

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

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

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

Highlighted
Best Response confirmed by RoxyWolf (New Contributor)
Solution

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

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