Excel

[spooferfish]

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?

[lordkafei]

This will probably help you: http://rsdo.net/RSDOnline/Guides/Experience%20formula.html

[Guest Rob]

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).

[spooferfish]

This will probably help you: http://rsdo.net/RSDOnline/Guides/Experience%20formula.html

It 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?

[Sy_Accursed]

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 red

false output is another if to determine if its white.

true output is white. false is yellow.

[spooferfish]

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 red

false 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"))))))))

[Sy_Accursed]

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

[mindstormer398]

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: typo

Also 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.

[spooferfish]

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

Turns 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.