rpg style level up formula?

thanks for that, but is there a way to manually set the requirements?

I should have explained myself a little better but I was extremely tired when writing my original post :p

Here is an experience table that i would like to replicate.

http://tibia.wikia.com/wiki/Experience_Table

as you can see,

level 1 = 0 experience
level 2 = 100
level 3 = 200
level 4 = 400
level 5 = 800
level 6 = 1500
level 7 = 2600

etc. etc.

I dont mind manually entering the values to avoid complex equations but sadly my knowledge with excel is limited. I have however played around with various game making programs and have made some crude rpgs with level up systems, again with crude lines of code along the lines of

if global.experince > 0
global.level=1

if global.experince > 100
global.level=2

if global.experince > 200
global.level=3

and so on.

is there anyway to do something similar in excel? for example

if A1 > 0
B1 = 1

if A1 > 100
B1 = 2

if A1 > 200
B1 = 3

etc.

again, i dont mind manually entering the variables if it makes things easier.

At this point, i think i should explain why im doing this haha. im trying to get my son to exercise more and he is really into his video games, so i wanted to create an excel file that keeps track of how many meters he has run in total. if he runs 100m he is level 1. if he runs 200m he is level 2. the plan is to give him some small rewards every 10 levels.

Im using the experince table i posted as an example because its one of the games he spends the most time on and Im hoping it will motivate him to keep fit and get outside a little :p

vlookup will also be advisable to use. create a table of experiences and level.
or
If you have some kind of a calculation to determine the level like the one you posted in the link you can post it.


this is the formula in the link to determine the Experience in the table
=50*A2^3/3-100*A2^2+850*A2/3-200

so if you have the table use vlookup or index/match