=PROB(A2:A5,B2:B5,1,3) returns the probability that x is between 1 and 3 : PROB « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. PROB
Input the formula: =PROB(B2:B5,C2:C5,1,3). Press Enter to get the result.
21.60.PROB
21.60.1.PROB(x_range,prob_range,lower_limit,upper_limit) returns the probability that values in a range are between two limits
21.60.2.=PROB(A2:A5,B2:B5,1,3) returns the probability that x is between 1 and 3