spooferfish Posted August 9, 2011 Share Posted August 9, 2011 I have a summoning calculator, I guess you could call it. I update the number of charms I have, and it calculates the xp-worth of charms I have in my bank. Is there a way for it to tell me what level I am at, not just the current xp? I have an xp table on page 3 of the program. I thought I could work something out there, but I couldn't figure it out. Is there a way to do this? Link to comment Share on other sites More sharing options...
lordkafei Posted August 9, 2011 Share Posted August 9, 2011 This will probably help you: http://rsdo.net/RSDOnline/Guides/Experience%20formula.html PvP is not for meIn the 3rd Year of the BoycottReal-world money saved since FT/W: Hundreds of DollarsReal-world time saved since FT/W: Thousands of Hours Link to comment Share on other sites More sharing options...
Guest Rob Posted August 9, 2011 Share Posted August 9, 2011 I have a summoning calculator, I guess you could call it. I update the number of charms I have, and it calculates the xp-worth of charms I have in my bank. Is there a way for it to tell me what level I am at, not just the current xp? I have an xp table on page 3 of the program. I thought I could work something out there, but I couldn't figure it out. Is there a way to do this? You might be able to do that with an IF argument. Something like "IF (Cell) = > (exp) < (exp) (cell)=(level number)" This way, if it sees that you're say, at 7 million exp, it will display the number as "92" (I think 92 is 7m exp? If not, 93). Link to comment Share on other sites More sharing options...
spooferfish Posted August 9, 2011 Author Share Posted August 9, 2011 This will probably help you: http://rsdo.net/RSDOnline/Guides/Experience%20formula.htmlIt might, if it worked.. :unsure: I have a summoning calculator, I guess you could call it. I update the number of charms I have, and it calculates the xp-worth of charms I have in my bank. Is there a way for it to tell me what level I am at, not just the current xp? I have an xp table on page 3 of the program. I thought I could work something out there, but I couldn't figure it out. Is there a way to do this?You might be able to do that with an IF argument.Something like "IF (Cell) = > (exp) < (exp) (cell)=(level number)"This way, if it sees that you're say, at 7 million exp, it will display the number as "92" (I think 92 is 7m exp? If not, 93). I can't get that to work. It keeps telling me I have errors.EDIT: I got it to work. Can I put multiple IF's on one cell? Link to comment Share on other sites More sharing options...
Sy_Accursed Posted August 9, 2011 Share Posted August 9, 2011 couldnt you have a basic xp/lvl table such has tip.it has then apply a formula to look up current xp/outcome xp in said table but always "round down" so it goes to the closest below the xp value then display the corresponding level. also Yeah stacked ifs work, jsut a nightmare to write if they get too long! lol You just make the true and/or false outcome of the first if another if. so like you say use if to determine if its red.true output is redfalse output is another if to determine if its white.true output is white. false is yellow. Operation Gold Sparkles :: Chompy Kills :: Full Profound :: Champions :: Barbarian Notes :: Champions Tackle Box :: MA RewardsDragonkin Journals :: Ports Stories :: Elder Chronicles :: Boss Slayer :: Penance King :: Kal'gerion Titles :: Gold Statue Link to comment Share on other sites More sharing options...
spooferfish Posted August 9, 2011 Author Share Posted August 9, 2011 couldnt you have a basic xp/lvl table such has tip.it has then apply a formula to look up current xp/outcome xp in said table but always "round down" so it goes to the closest below the xp value then display the corresponding level. also Yeah stacked ifs work, jsut a nightmare to write if they get too long! lol You just make the true and/or false outcome of the first if another if. so like you say use if to determine if its red.true output is redfalse output is another if to determine if its white.true output is white. false is yellow. If I knew how to write that formula, yes I could do that.Stacked ifs sounds too complicated, lol. EDIT: I figured it out, the help function in Excel actually helped. Thanks for the help guys. If anyone was curious, here is the formula it wanted.=IF(B9>Sheet3!B91,"92",IF(B9>Sheet3!B92,"93",IF(B9>Sheet3!B93,"94",IF(B9>Sheet3!B94,"95",IF(B9>Sheet3!B95,"96",IF(B9>Sheet3!B97,"97",IF(B9>Sheet3!B98,"98",IF(B9>Sheet3!B99,"99")))))))) Link to comment Share on other sites More sharing options...
Sy_Accursed Posted August 10, 2011 Share Posted August 10, 2011 Yeah stacked if's get complicated; I ran an event spreadhseet for my clan that had a formula that ran to about 15 if functions.Tht was headache worthy Operation Gold Sparkles :: Chompy Kills :: Full Profound :: Champions :: Barbarian Notes :: Champions Tackle Box :: MA RewardsDragonkin Journals :: Ports Stories :: Elder Chronicles :: Boss Slayer :: Penance King :: Kal'gerion Titles :: Gold Statue Link to comment Share on other sites More sharing options...
mindstormer398 Posted August 15, 2011 Share Posted August 15, 2011 Say you have the list of xp values for each level in a vertical list that starts in cell x10 and goes to x109. Use this formula to return the level number based on input xp from cell a1: =MATCH(A1, X10:Y109, 1) This just returns the relative index of the cell in the matrix (2nd argument) that is the smallest not larger than (that's the logic that the 3rd argument, 1, tells the function to use) the initial comparing value (1st argument). If you want I can upload a sheet I have that tracks my personal goals and uses this extensively. E: typoAlso here's some relevant excel help for this function: MATCH(lookup_value, lookup_array, [match_type]) Match_type Behavior 1 or omitted MATCH finds the largest value that is less than or equal to lookup_value. The values in the lookup_array argument must be placed in ascending order, for example: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE. 0 MATCH finds the first value that is exactly equal to lookup_value. The values in the lookup_array argument can be in any order. -1 MATCH finds the smallest value that is greater than or equal to lookup_value. The values in the lookup_array argument must be placed in descending order, for example: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and so on. +-------------------------+| . . . . Pure F2P . . . .|+-------------------------+| || 73 74 73 75 70 86 65 80 || || 85 80 80 80 80 80 80 65 |+-------------------------+| Combat: 092 Total: 1235 |+-------------------------+ Link to comment Share on other sites More sharing options...
spooferfish Posted November 20, 2011 Author Share Posted November 20, 2011 Yeah stacked if's get complicated; I ran an event spreadhseet for my clan that had a formula that ran to about 15 if functions.Tht was headache worthyTurns out mine didn't work. it never changed :( Say you have the list of xp values for each level in a vertical list that starts in cell x10 and goes to x109. Use this formula to return the level number based on input xp from cell a1:=MATCH(A1, X10:Y109, 1)This just returns the relative index of the cell in the matrix (2nd argument) that is the smallest not larger than (that's the logic that the 3rd argument, 1, tells the function to use) the initial comparing value (1st argument).If you want I can upload a sheet I have that tracks my personal goals and uses this extensively.E: typoAlso here's some relevant excel help for this function:MATCH(lookup_value, lookup_array, [match_type])Match_type Behavior 1 or omitted MATCH finds the largest value that is less than or equal to lookup_value. The values in the lookup_array argument must be placed in ascending order, for example: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE. 0 MATCH finds the first value that is exactly equal to lookup_value. The values in the lookup_array argument can be in any order. -1 MATCH finds the smallest value that is greater than or equal to lookup_value. The values in the lookup_array argument must be placed in descending order, for example: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and so on.This also did not work. This is frustrating now :( :wall: *EDIT*Nevermind, I'm an idiot. It works just find if I tell it the right cells. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now