Hi, sorry i am still an excel newbie here. and i have a question.
i would like to generate random number from column D with effect on the probability from column A
but however, i keep getting errors such as #NA and the numbers generated does not make sense, as my probability say 30% is the highest among them, and yet it dont really appear much


test.jpg