I am trying to create a calculator for this mobile game that I play (Lord’s Mobile) but cant seem to figure out the formula.
1) In this game, you can get your upgrade time reduced when your guild members press a “help” button.
2) A single “help” reduces your current time by 1%. So if someone presses help, your time (X) = (Time-(Time*0.1)). When another person presses help, it would be Y = (X-(X*0.1)), then Z=(Y-(Y*0.1)), so on and so forth, where each new letter represents the new time.
Another example: If your total time is 24 hours (1,444 minutes):
Help 1 would be (1,444-(1,444*0.1)=1,300min left;
Help 2 would be (1,300-(1,300*0.1)=1,170min left (and so on).
3) There is a minimum (or maximum?): Once 1 minute > 1%, it reduces by 1 minute instead.
4) Castles can be levels 1-25. The amount of helps you can receive depends on your castle level. The amount increases consecutively, with Lvl 1 being 5 times, and 25 being 30 times.
With all of these factors, I can’t seem to figure out how to calculate this in my spreadsheet. Even without the additional factors, I was at least trying to figure out how to do the whole “1% Reduction” in one cell.
I was hoping some math genius might see this. And even without the math help, I’m posting this here because I don’t know the correct syntax. Anyone have a clue as to what to do? Thanks!
=IF
; Don't hesitate to share a sample with desired results, conditions, etc.. for us to better understand and help you. Moreover there are a lot of communities out there for this game and i'm sure someone already made this kind of spreadsheet. I found this : docs.google.com/spreadsheets/d/… – pjmg Aug 10 at 7:42