I just learned of the LET() function and wanted to thank this community for it; Shortening Formulas
I was trying something seemingly simple. I have 3 Players, each rolls a 20 sided die. Each one has a different Bonus, a +X, to their result. Then trying to math out the probability of 0,1,2 or 3 Players being at or above a specific target number. (The Problem comes from Dungeons & Dragons to see how likely the group is to succeed on a task where every player has a different bonus and half/all of them need to succeed.)
The result looks like this. The big Table to the Side lists the probability for each bonus to hit a specific target number, with MIN and MAX functions to make sure I'm always inbetween 0 and 1. The first entry looks like this and is then just expanded in every direction.
=MIN(1;MAX(0;(21-H$2+$G3)/20)) || (21-Targetnumber+Bonus)/20
Posted Nov 14, 2025, 2:08 PM UTC
10