Maths problem - working out percentages
Favorites|Homepage
Subscriptions | sitemap
HOME > > Maths problem - working out percentages

Maths problem - working out percentages

[From: ] [author: ] [Date: 12-04-13] [Hit: ]
000. Of course, the number 201 monsters will be changing as I progress, but a spreadsheet formula should update that.-1st bit: you dont 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,......
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.

-
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

-
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
1
keywords: out,problem,Maths,percentages,working,Maths problem - working out percentages
New
Hot
© 2008-2010 http://www.science-mathematics.com . Program by zplan cms. Theme by wukong .