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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,365
Members
410,679
Latest member
rolandbianco
Top