Information for moderators.

Auto-translated

Harik

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.

Yes, I know that when HP>35, it calculates incorrectly. I've now corrected all the formulas, and it now calculates correctly when HP>35 and when the number of possible demons exceeds the number of units in the stack. I just need to fix one formula for the case when HP>35 and the number of demons is greater than the maximum possible. It's just that in Excel, all these multi-level formulas are written in one line, which makes it very difficult to fix them

Reading content in

Interface language

Information for moderators.