Greetings,
My question is this, I am good with excel but I’m unsure what the max lenght of a formula is which is why I don’t think this next thing can be done. Right now I have a friend who wants me to program a character sheet for a RPG he started. He wants the EXP for the next level to automatically change once the experience the character already has moves up to the the next level. I figured out a formula to do this however he has about 200 level’s I need to imput so before I do this I need to know if Excel would support it.
The current formula I use is this:
=IF(F5<500,"500", IF(F5<1000,"1000",IF (F5<1500,"1500",IF(F5<2000,"2000",IF(F5<2000,"2000")))))
Its basic. Right now F5 is the value of exp the character has earned, F6 I have another formula that subtracts F5 from F7, and in F7 I have that huge formula above.
So it looks like this
Experience Earned (F5): 99
Experiennce Remaining (F6): 01
Next Level (F7): 100
Is there a way I can use the formula I put above for F7 and extend it to so it will use 200 different IF conditions or is this even supported or is there an easer way to automate this?
Thanks for the help