March 6, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Calculating dnd proficiency bonus using excel?

I'm trying to get excel to automate calculating character sheet numbers for me, what I need is the following:

when I enter 1, 2, 3 or 4 in cell C2, I want the next cell to say 2.

When C2 says 5 to 8 it should equal 3

9 to 12 should equal 4

13 to 16 should equal 5

and finally 17 to 20 should equal 6

Thanks in advance!

Check out the full article on the original site

#Excel alternatives for data analysis

#Excel compatibility

#Excel alternatives

#rows.com

#natural language processing for spreadsheets

#generative AI for data analysis

#dnd proficiency bonus

#excel

#character sheet

#calculate

#automate

#excel formula

#cell C2

#score range

#Dungeons and Dragons

#number conversion

#data input

#conditional logic

#output value

#input data