Excel Probability Function - How to check and apply probability

Ok, so I am wondering if this is possible.

let us imagine we start with 0 points and there is an 80% chance every time you roll the dice for it to increase by 5 points but if it fails it decreased by 5 points. But heres the thing, it costs you 80 million per 5 points you are trying to achieve so if you had 5 points and your next roll was trying to achieve 10 points then it would cost you 160 million for that chance.

I hope that makes sense, i have attached the spreadsheet. I wasn't sure if excel was able to generate values based on probability.

Originally Posted by avk

In excel apply
=prob(x_range,prob_range,lower_limit,upper_limit)

Thanks for the reply. i tried that but couldn't get it to work. could you try it on the spreadsheet i attached and see if it works for you?

Thanks

Jack