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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,119,091
Messages
5,576,049
Members
412,697
Latest member
khanhvy31
Top