Using a spreadsheet to work out average drop rate of my slayer monsters in runescape. At the moment, it says I have killed 201 monsters. I got 76 crimson charms, so on average what percent of the monsters drop crimson charms?
Well I did, 76/201 x 100 but I got 3781%.
As well as that, I'd like to work out on average how many crimsons will I get per 100, 1000 and 10,000. Of course, the number 201 monsters will be changing as I progress, but a spreadsheet formula should update that.
Well I did, 76/201 x 100 but I got 3781%.
As well as that, I'd like to work out on average how many crimsons will I get per 100, 1000 and 10,000. Of course, the number 201 monsters will be changing as I progress, but a spreadsheet formula should update that.
-
1st bit: you don't need the " x 100" because you probably have already changed the cell number type to number:percentage.
2nd bit: in the cell where you want the number per 1000, you just put "=1000 x (cell where the % is)
Etc
2nd bit: in the cell where you want the number per 1000, you just put "=1000 x (cell where the % is)
Etc
-
Calculation error, your method is fine. 76 is clearly less than 201 so you'll get the appropriate sub-100% value. Try (76/201)*100
-
its 201/76 x 100 = the percentage
i cant help with the rest, i have no idea what youre going on about for the rest of it
i cant help with the rest, i have no idea what youre going on about for the rest of it