Feb 06 2020 08:28 AM
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
Feb 06 2020 08:41 AM
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).
Feb 06 2020 08:46 AM
@macrordinary putting in this info makes C1 and C2 say #NAVN?
Feb 06 2020 09:11 AM
SolutionI 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
Feb 06 2020 09:11 AM
SolutionI 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