Spreadsheet Nerdery

In the unlikely event you ever need a spreadsheet cell to tell you what level someone’s 3rd or 3rd-and-a-half D&D character is based on their experience points, this should do it (in Google Docs Spreadsheet):


=FLOOR( (SQRT(ABS(-1 - (8 * CELL-CONTAINING-XP/1000) ) ) + 1)/2, 1)

You’re welcome.

Tags: , , , ,

Comments are closed.

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit our friends!

A few highly recommended friends...