Auto-translated
I can't seem to find how to make the hero's movement points display in the status bar in Heroes.
New here? I'm Roha — want a quick tour?
dom2 (red Barbarian) - Scorpion (swamp) jebus
Please send me a message on ICQ with your number.
034-155-185 movie cmka
Added 1 hour 51 minutes ago
981-329-463 kuno Balance
Before, it was impossible to calculate anything because the patterns were unknown. I don't understand why anything needed to be changed in this regard.
I, like many others, have had these schemes for about a year now.
If you sacrifice 3 units with 50 HP each to create demons, Excel will calculate 4 demons (which is incorrect). As statistics show, the number of demons decreases when it ends in 3 or 9.
=IF(AND(hp>0, B3>0), MIN(F1, IF(hp<=35, ROUNDUP(hp*B3/35, 1), B3)), 0) – this is how you should calculate the number of demons.
Why is there a second sheet? Everything is calculated, for example, like this, to calculate the number of sacrifices for potions.
=IF(AND(B1>0, B2>0), IF(hp<=35, ROUNDUP(F1*35/B2, 1), F1), 0).
The number of excess/sufficient sacrifices is also very difficult to calculate.
PS: If one of the values in the inner IF statement matches one of the values in the outer IF statement, use AND(; ) to simplify the structure.
when the number of possible demons exceeds the number of units in a stack...