Finding an inverse resultInverse results

Question

Level 1

8 points

Finding an inverse resultInverse results

I am working on a TTRPG system and have run into a problem.

B. C. D. E. F. G. H. I. J. K. L

I need the numbers in cell F21 (Proficiencies (d20)) to read a lower number, the higher the value it reaches. The current formula in F21 is:

ROUNDDOWN(($C$13+$C$14+$C$11)÷3,0)

C11 is DEX C13 is INT C14 is WIS

The equation would be DEX+INT+WIS / 3

However as you can see, the current value is 18 when I need it to show something closer to 2, or 3 or even 5. This is because a player needs to roll above this number to succeed. It would be logical (I think) that the higher the above scores, the lower the roll needed. I just don’t know how to get Numbers to do that.

A little help with this would be greatly appreciated.

iPad, iPadOS 17

Posted on Jul 18, 2024 9:30 PM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

31,002 points

Jul 19, 2024 10:24 AM in response to Algoroth

It could probably be done with formulas but I think a lookup table would be easier and more versatile. Lets say your rolls can be 1-6 and the proficiencies can be 0-20.

Column B is not necessary for any formulas, just for looks. The proficiency increase from row-to-row is the range of the proficiency (20-0) divided by the number of possible answers (6). 20/6 = 3.33. You can change the numbers from one row to the next if you want to skew the results.

The formula in F21 would be

=XLOOKUP((C11+C13+C14)/3, Sheet 2::Table 1::A,Sheet 2::Table 1::C,"",−1)

Reply

Answer 2

Algoroth Author

Level 1

8 points

Jul 19, 2024 8:09 PM in response to Badunit

I’ll have to give that a shot. Thanks.

Reply