hiya can anyone help to do the following , i have a cell called daily sales and i need the numbers bellow to appear in that table according to the probabitity. for example the number 50 will appear in the cell 40% of the time and number 45 will appear 20% of the time and so on, i think i need to use a lookup table but not sure, is this possible in excel if so can someone help me please
thank you
thank you
Code:
Daily sales 40 45 50 55 60
Probability 10% 20% 40% 25% 5%