Hello. My brain just exploded inside my head from me trying to figure out how to make a certain formula. I hope someone here can help me. This formula is for a strategy war game, and here is the scenario: I have 50 infantry soldiers each worth 10 units of offense. This represents a total offensive force of 500. That would be an easy formula. Now enter the "special character". Let's say this special character boosts the offense of infantry soldiers by 5, but it can only boost 20 infantry. Sure I could purchase another special character then I would be able to boost 20+20 or 40 however the last 10 infantry would not be boosted. Now to calculate the total offense of 50 infantry and 2 special units the formula would also be easy, but we have the remaining 10 unboosted soldiers. For some reason this seems beyond complex to me when i try to program a formula for it. I am no Excel pro, and I never took a course. I have, however, learned a lot about this program just from the need for spreadsheets in this game.
Bookmarks