Probability in excel using lookup?

chasey

New Member
Joined
Oct 23, 2006
Messages
1
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




Code:
Daily sales	  40     45	    50	55    60

Probability	  10%   20%       40%   25%    5%
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,119,175
Messages
5,576,544
Members
412,730
Latest member
Thundereagle
Top