Thanks for the formula help I figured out what the problem is one bid is set to 13,000 the other varies with the formula <TABLE style="WIDTH: 265pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=353 border=0><COLGROUP><COL style="WIDTH: 265pt; mso-width-source: userset; mso-width-alt: 12909" width=353><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 265pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=353 height=17>=INT(lowest+(highest-lowest+1)*RAND())</TD></TR></TBODY></TABLE>
how would i figure out the probability of 13000 being higher than the random. lowest=10500 highest=30000