Dice for RPG

[Alan Stevenson]

Hi

I'm wondering if anyone could advise me, please?

Now the kids are at an age where they want to do their own thing, I'm going bck to my youth and playing solo RPG's. I was hoping to do something in Excel which deals with dice rolling. I can put together a simple roller to give me x-number of independent 6-side dice rolls, but the game I'm playing uses a policy of 'doubles add and roll over", eg:

Die 1: 4

Die 2: 2

Die 3: 2

Total: 8, but then I roll again for the 2's and add that sum to the 8. If all 3 dice were 2's, I'd total as 6 and re-roll all three.

The problem is I have absolutely no idea to go about this in VB (or even just a formalaic approach in cells).

Does anyone have any advice or solutions,please?

Thank you.