this post was submitted on 27 Aug 2023
8 points (100.0% liked)
Pathfinder 2e General Discussion
79 readers
1 users here now
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
If you put the die type along the top row (just the numbers, no d) and this in A2 it should do what you want.
=RANDBETWEEN(1,A$1)
You can copy the cell without editing the formula and fill as much of the sheet as you want. Press F9 to reroll.
If you prefer a percentile die with zero, you can change it to
=RANDBETWEEN(0,9)*10
Or just combine the 2 dice as a single d100
Oh that works even better since there's no "21" showing up! Thank you.
Does PF2E even use percentile dice? LOL
…huh. I guess not. Somehow I never noticed that before.
This is basically what I do as well.
One thing I find useful is to list your party's Perception modifiers, use the formula above for a random d20 result for each PC, then add them together (for example, =B2+C2). Then when they walk into a room, hit F9 for an instant whole-party secret Perception roll.