this may be an odd request, but is there any way to check a cell for a numeric value and display a level depending on what it is?
for example, i would like to check cell A1 (experience points). if its value is more than 100, cell B1 (level) will display 1. if A1 is greater than 200, B1 will display 2. if A1 is greater than 300, B1 will display 3 etc. etc.
basically i want to check the value of one cell, and adjust the value of another accordingly.
I hope that makes sense.... its pretty late here.
Bookmarks