Forum Discussion
Solved
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 ...
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
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).
macrordinary putting in this info makes C1 and C2 say #NAVN?